stevem Posted June 27, 2005 Share Posted June 27, 2005 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. Quote Link to comment Share on other sites More sharing options...
stevem Posted June 27, 2005 Author Share Posted June 27, 2005 Just found the answer elsewhere on this site. Instead of using = in WHERE statement for all used LIKE and posted % for value in form. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.