Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enter Parameter Value for print macro

Status
Not open for further replies.

Cheryl13

Technical User
Nov 10, 2003
8
CA

Hi, I have a database (Access 97) in which the user inputs data into a form and hits the print button and it prints a report for the record they are on (using a macro). Everything was working fine with the user opening each form individually and printing. I then decided to group all the forms into only 2 forms (one for Pipelines and one for Facilities) using the tab control. I revised the macros so that they now go to the Pipelines Applications/Facility Applications where:
[MainTable]![Requisition#]=[Forms]![Facility Applications]!
[Requisition#] or
[MainTable]![Requisition#]=[Forms]![Pipeline Applications]!
[Requisition#]
All of the forms in Facility Applications print fine.
But, in the Pipeline Applications when you hit print, a box
comes up saying Enter Parameter Value Forms!Pipeline
Applications!Requisition#

I have checked all the properties in both sets of forms and unless I am missing something - they are exactly the same. The print macros also all seem to be the same.
Any ideas what I'm doing wrong? Thanks!
 
This is just a wild guess, but perhaps you could create a hidden field (or perhaps two) on the main form. Then, before calling the macro, add a line or two that copies the needed parameter to the appropriate hidden field. Then set the parameter reference to the field on the main form. Perhaps it doesn't like working with subforms.

As I said, this is just a wild guess, but since you received no response, I thought I'd take a shot.

You might also need to create a function that sets itself equal to the variable and then set the parameter equal to the function.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top