Query by Form question

[BAzZ]

I've got a search form which uses the Query by Form code from MS web site http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242 This all works, except for one of the fields is a drop down list, if I select a name and do the search no results are displayed, I can do a case statement for every entry in the drop down list, but there are over 50 entries. Is there a way for me to do the search just using what I select from the drop down list?

Thanks

 

[SforSoftware]

You can check the value of the combobox in the same way as for a textbox. But one thing you've to think about: a combobox has a 'dependent column' in its properties. This gives the column with the saved value, what might be different from the shown column.

Succes,
Bert