It's a little complicated to explain, but I'll try. Access 2007 is being used.
What I'd like to do is have my users select a button on the switchboard. This would bring up a form consisting of a combo box with the selection criteria (say employee names) and a "create report" button.
When a user choses an employee from the combo box and hits the "create report" button on the form, a report showing information on that employee would come up on the screen.
I think what I'm trying to do is have the value of the combo box become the criteria of a query on which the report is based.
Is that even possible?