Print multiple reports from Command Button with Filter

[LDMueller]

In Access 2003, I have three reports, named as follows:
rptScale
rptSummary
rptComments

All three reports pull information form the same table (e.g. Users).

I want to create a command button which will prompt for the "UserInitials"
and print all three reports filtering on the field "UserInit".

Can anyone help me?

Thanks!

LDMueller

 

[Tom van Stiphout]

On Wed, 22 Jul 2009 06:26:01 -0700, LDMueller

One way to do that is from your "Run Reports" button to first open a
new form, with a dropdown with valid UserInitials, or a textbox.
That form will have a Preview button to run the reports, and in the
DoCmd.OpenReport calls, set the WhereClause argument to something
like:
"UserInitials='" & Me.txtUserInitials & "'"
(note how I wrap the value in single-quotes)

-Tom.
Microsoft Access MVP

 

[LDMueller]

Perfect, thank you so much!

LDMueller

On Wed, 22 Jul 2009 06:26:01 -0700, LDMueller

One way to do that is from your "Run Reports" button to first open a
new form, with a dropdown with valid UserInitials, or a textbox.
That form will have a Preview button to run the reports, and in the
DoCmd.OpenReport calls, set the WhereClause argument to something
like:
"UserInitials='" & Me.txtUserInitials & "'"
(note how I wrap the value in single-quotes)

-Tom.
Microsoft Access MVP

 

[David W. Fenton]

One way to do that is from your "Run Reports" button to first open
a new form, with a dropdown with valid UserInitials, or a textbox.
That form will have a Preview button to run the reports, and in
the DoCmd.OpenReport calls, set the WhereClause argument to
something like:
"UserInitials='" & Me.txtUserInitials & "'"
(note how I wrap the value in single-quotes)

I use class modules for this. That is, you open the filter form, set
the properties of the class module, then run the reports, which are
set to check the class module instance to see if any relevant
properties for filtering are set.