Jump to content


Photo

Selecting either or both


  • Please log in to reply
1 reply to this topic

#1 stevem

stevem
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 27 June 2005 - 08:38 PM

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.


#2 stevem

stevem
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 27 June 2005 - 09:51 PM

Just found the answer elsewhere on this site.

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users