Sorry, that was a bit confusing reading back over it. I have a form with 3 buttons on it for user to push to open a report. If the user pushes the bartender button it will open a report listing the bartender information that i have already entered into a table. The format of the Report wil look the same regardless of which button is pushed except the title. Hope that explains it better

Im new to VB/Access. I have a table listing employee information and then 3 different queries that seperate the employees by job title (Waiters, Dishwashers, Bartenders). What i would like to do is have 3 buttons (1 for each) that when pushed opens a form displaying all the information in a report. The kicker is the template for the report will remain the same, only the title will change (either waiter, bartender, or dishwasher). I see no reason...