combo box query help

[b9791]

How would I go about setting up a form with a combo box listing all of the available options to search for on a particular field and then have the user click on a button to display the results in a subform?

FOr example, I have a table of Categories and I want the combo box to list all of the categories. I want the user to be able to click the drop down and select the appropriate category and then click a button to display all records that fall in that category.

--Brian

 

[Pat Hartman]

Create an unbound combobox on the form. Use the wizard and choose the option that says to find a record on the current form.

 

[adwaitjoshi]

Use the wizard to create a combo box to search records. It will ask you to select the category on which you want to find the records. It will automatically generate the code for you ni which it searches the record set and bookmarks it. Keep the combo box unbounded if you donot want to store the values anywhere. I hope this works for you.

Adwait

 

[b9791]

Thank your for your help, it worked great.