Enter Parameter Value ?

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

Hi, I have a database 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 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 the properties of the forms and they appear
to be the same for both. I have also checked all the
print macros and they also seem to be the same.
Any ideas what I'm doing wrong? Thanks!
 
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.
 
Back
Top