Using a combo box in a search form

[MSG56]

I'm creating a search form for a food recipe database. I would like to be able to search for recipes based on several different criteria. I’ve created a test form with only two unbound text boxes that works exactly as expected. I’m using the LIKE property in the query in a way that allows me to leave the text box blank and return all the records. Or type part of a word and return all records containing the entered text.



For some of the parameters that I wish to search it would be easier to limit the search items by using a combo box in place of the unbound text box. When I convert one of the text boxes to a combo box the query no longer works as expected. If I don’t select anything in the combo box, all is good as the query still returns all records. However, if I select any item in the combo box the query comes up blank. What I’m I doing wrong?

[pbaldy]

My guess is that the bound column of the combo is the ID field, which would give you an apple to oranges comparison.

[qa12dx]

should work. i'm guessing the "search now" cmd button triggers the query. what is the method you are using here? also a suggestion, don't have query criteria's when possible. use the apply filter. that way you can use the same query at many places and filter the content as required at that form, report, etc.

[MSG56]

Sorry for the delayed response - been busy and haven't worked this in a while.

I started tinkering with this again today and I've resolved my initial problem, but I'm not quite sure how that happen. Now, I'm on to the next issue.