Asking for Parameter

C

Carrie

Hi, I have a database in which the user inputs data into a
form and hits the print button and it prints 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 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#
Any ideas what I'm doing wrong? Thanks!
 
S

Steve Schapel

Carrie,

If you are using a tab control, it would appear that your forms are now
subforms on the main form that contains the tab control. Therefore your
syntax in the Where Condition argument of your OpenReport macro needs to
be along these lines...
[Requisition#]=[Forms]![MainForm]![Pipeline Applications]![Requisition#]

By the way, as an unrelated side issue, it is not a good idea to use a #
as part of the name of a field.
 

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

Top