Lookup with a Query

[Stemdriller]

Trying to use a query to select a 'Category' from a table. eg. Soccer posts, the query will then show all records for 'Soccer Posts'.

At the moment I simply use the [Enter Category] within the query, but would like to be prompted to be able to select a 'Category' automatically when the query is run.

 

[Alansidman]

Is this what you would like to do?

http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

 

[Stemdriller]

Alan,

Thanks for that, yes a big help, the query now lists all the products. But can I get the query to give me a list of available categories to select from rather than the user having to type specific ones.

So that if add a category the query will see rather than me telling everyone that there is a new category?

 

[Alansidman]

Yes, you can do that. You need to change the text boxes in your search form to combo boxes. There are three tutorials at the same web site I gave you before on how to do combo boxes.

http://www.datapigtechnologies.com/AccessMain.htm

That will give you what you need. If you want to add a not in list option, then you will need to go here.

http://allenbrowne.com/ser-27.html

Good Luck.
Alan

 

[Stemdriller]

I can't get the stupid thing too work. The combo box works and I can select the category I want, but It will not display all relevant records.