Query by Form Questions

[nakedbamboo]

I am making a query from a form based on the Microsoft example,

http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242,

and everything is working well except for a few fields. Does a query by form only work with text boxes? I have some option buttons and a combo box that I would also like to allow the user to select from to search. How would I incorporate these into a QBF? An example would be great because I am not real VB fluent. Thanks.

 

[cghoga]

You can use checkboxes and comboboxes (also listboxes). the trick with the checkboxes is that checked = 1 and unchecked = 0 (or -1 I can't remember). you should be able to treat option buttons much the same way.