I am using Access 97 and I am trying to print a report using a macro. The macro pulls from a query that checks to see what report to print by looking at a combo box when a button is pressed. The combo box pulls it's list from the same table that the report is trying to print. How do I solve this because the list that the user selects from must contain up to the most entered data in the table.
I haven't used access in a while...I used to do this in my sleep now I can't do it with 8 cups of coffee.