Hello, I am new to Microsoft Access and I have a couple of instructional books on it. What I am trying to do is be able to print two separate forms using one button. What I had to do is create an interactive form, but the form had too many options, so I had to split it into two separate forms. The forms will need to be printed after completion, and I was just wondering if anyone has any way that I can just attach one print button to pg. 2 and have it print both the first and second page. Thanks for your help!

Matt

You are printing forms? Are they both open at the same time? When you say "pg 2," do you mean that you have a tabbed form? Or two seperate forms? Why not print a report based on the information on the two forms?

mmcdonal

hmm.. I haven't thought about this. I guess that's kind of elementary. It is not a tabbed form, but two separate forms. I guess I should try the report route, that may be easiest.

Though about that, sorry, typo.

You can take some query or value from the form, and then package the report using the value. For example, create a query that has all customers plus all their outstanding orders, let's say. Then take their customer number from the form, and run the report WHERE [CustomerNo] = Me.CustomerNo. You can either pass the parameter to the report on the DoCmd.OpenReport where clause, or you can create a query that has this in the Criteria line for the field you are passing (CustomerNo in this case):

[Forms]![frmMyCustomerForm].[txtMyCustomerNoField]

Did any of that help?


mmcdonal