I found quite a few subjects in the forum dealing with this question, but I need even more basic instruction on this.

I have a list of 40 names that I want to be available in a combo box on a form, then the name that is picked be the criteria for a query that will produce a report. I have no idea how to get the name picked in the combo box to be the query criteria. I normally use a macro for things I want to happen. I have used basic VB but I think this is beyond me, and could really use some help.

Thanks
Stacey

In the query that feeds the report, set the criteria for the field that you want to filter (it will likely be an ID field) on to

=Forms!NameofYourForm!NameofYourCombo (assuming that the combo columns are ID;Name)

and this will filter the report accordingly.

Thank you so much!