Drop Down Lists

[briandrago]

I want to create a form that lists all of the possible brand names from a query, once that brand is selected, it will open up a report that shows all of the information regarding that brand. How can I do this?

I've tried Microsoft Help but I can't seem to find the answer to my specific question.

Thanks for your help.

 

[pbaldy]

This technique, which also works for reports, would be one way:

http://www.baldyweb.com/wherecondition.htm