Query form

[Ed3m]

Hi
I have a stock control database and would like to create a form where a user can use predetermined numbers in a combo box to search for items which are low in stock eg if 10 was selected, items with 10 or less available would be shown. Any help would be appreciated.
Thanks

 

[vconfused]

Create a plain Select query that returns all of the results.
Then create a form that has the combo box with your choices and in the properties of the combo box, give it a name. Then save the form.
Then go back and open the query in Design View. For the criteria of the field with the numbers, type in "<=" (without the quotes) and then the forms![formname]![comboboxname] (i.e. "<=forms![myform]![mycombobox]"). Then save both and as long as the form is open with something in it, when you run the query you will get your results. Now if you run the query when the form is closed, it will prompt you for the number.