Jump to content

Archived

This topic is now archived and is closed to further replies.

stevem

Selecting either or both

Recommended Posts

Hi,

 

New to this would appriciate some help.

 

Using drop down list to select column from table.

Can select either F for FULL or E for EMPTY.

Would like third choice of A for ALL.

 

When I select A it does not display any records from my recordset.

 

not sure what I am doing wrong.

 

Share this post


Link to post
Share on other sites

Just found the answer elsewhere on this site.

 

Instead of using = in WHERE statement for all used LIKE and posted % for value in form.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.