MS Access Reports

[Vince323]

Hi,

I have several reports showing user information. What I would like to do is print all reports for a single user name.

Can I have a combobox with all usernames in and then create some way of printing the reports relating to that username.

Hope that makes sense.

Thanks

 

[nberryman]

Create a blank

Use the Combo box wizard to create a combo box that looks up the name

Give the combo box a meaningful name and save the form and leave it open

Create or open a query to look up the name you want and in the ID FIELD (the combo box will have the ID and display the name) click in the criteria field and click the Build button

Use the Expression builder to navigate to the form and the combo box and clicl ok

repeat on each query for each report.

Create a macro to

Open report
Print repot
Close report

repeat in the same macro for each report.

Finally, use the command button wizard to run the macro.

Easier to do than it sounds, any problems re-post



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[Vince323]

Thanks for your reply.

How does the macro link to the combo box?

Sorry I am quite new to this.