Tags: access, aform, button, database, enter, forthe, hits, inputs, microsoft, mysql, oracle, parameter, print, prints, recordthey, report, sql, user, value

Enter Parameter Value ?

On Database » Microsoft Access

2,818 words with 1 Comments; publish: Mon, 26 May 2008 13:08:00 GMT; (250187.50, « »)

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!

All Comments

Leave a comment...

  • 1 Comments
    • 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.

      Steve Schapel, Microsoft Access MVP

      Carrie wrote:

      > 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!

      >

      #1; Mon, 26 May 2008 13:09:00 GMT