Macro for Multiple Reports

[DFeil]

I have created a macro that will open six reports. Each report gives a prompt for definition criteria, such as First Name? and Last Name? How do I get it so when I run the macro, I only have to enter the defining info only once, instead of six times individually?

 

[pbaldy]

Have the user enter the criteria on a form, and have each query/report get the value from there. Most of us use forms to gather user input; you have much more control that way.

 

[DFeil]

I think I understand, for an example I would have to create a form will all my employees First and Last Names. How do you get the query to check the form for the info? Thank you for your help.

 

[pbaldy]

Instead of:

[Enter name]

in the criteria, you'd have:

Forms!FormName.TextboxName

You can use the Build feature in the criteria to build the path for you.

 

[DFeil]

Thank you, I will give it a try.

 

[pbaldy]

No problem, and welcome to the site by the way!

 

[DFeil]

Thanks for the welcome.

 

[DFeil]

Ya, that didn't work for me. I was able to create an expression in each query to combine the first and last names, so the criteria only asks for the full name now, instead of two different criteria boxes. Each query/report only asks for one criteria each now. But I still can't figure out how to Choose a name from a drop box, to run all querys when I run the macro.

 

[pbaldy]

It should work fine, provided the combo returns a value consistent with what the query is looking for. Can you post the db with that effort?

 

[DFeil]

Its about 20mb in size, I will send you a dropbox link to it. Thank you again for your help.

 

[DFeil]

There used to be a link here, I removed it.

 

[DFeil]

I've got it figured!

 

[pbaldy]

Glad you got it sorted. The link didn't work for me, and I got busy and forgot to post that here. Sorry about that. :banghead: