Using a macro to print 2 reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that prints a report when data is present. I want to be able
to check the table if not data print another report. Can you or how do you
setup a macro to do this. Thanks
 
Kdzobel,

See my reply in another newsgroup.

Just a hint for the future... If you feel it is important for your post
to appear in more than one newsgroup (in practice, this is seldom
necessary), it is preferable to cross-post (i.e. address the same
message simultaneously to both groups), rather than multi-post (i.e.
send a separate copy of the message to each group). Thanks.
 
If Me.yourfield = "Temp" Then
DoCmd.OpenReport "ReportNameTemp", acViewPreview
Else
DoCmd.OpenReport "ReportNameOne", acViewPreview
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sorting and grouping using multiple tables 0
Access Access Report Works on One Machine but not Another 3
How can I link tables with a form? (2007) 0
Printing reports 1
Changing the page setup for printing 2
Report duplicates 0
Excel print area which only prints pages of worksheet which are active 0
How to Print a Subreport from a filtered search 1

Back
Top