combo box using query

[megavolt121]

I have a query that returns all of my results alphabetically. In my form I've created a combo box to display the results. So far it displays a combo box with only one entry in it, i have to click to the next page to see more. What i want is for all the results to be displayed in the combo box and i want it so when you select a item it will create a report(or a button that will link to the corresponding report).

 

[AccessAce]

Try setting the Record Source for the form to be blank.

Then set the Row Source for your combo box to the query that returns the results you want to list.

Set the AfterUpdate event of the control to open the report you want based on the value of the control box.

Hope that helps.