Print Button on Form Parameter Passing

[hext2003]

I created a query that I use to print a report so I can print just an individual account.

I now would like to create a button on the form to print this report but it asks me to enter the account number I want to print. Is there a way to pass it the current account number I am looking at in the form?

TIA

 

[Remou]

You can use a Where condition:
[tt]DoCmd.OpenReport "rptReport",,,"ID=" & Me.ID[/tt]

 

[hext2003]

Does the "ID=" have to be the exact wording of the critera? or the field name?

DoCmd.OpenReport stDocName, , , "Key=" & Me.Key

I have tried a few different ways and I keep getting a syntax error missing operator in expression '(key=992134)'

 

[Remou]

Is Key a text field? If so, you need some quotes:

[tt]DoCmd.OpenReport stDocName, , , "Key='" & Me.Key & "'"[/tt]

 

[hext2003]

Yes Key is a text field

I don't get the error message any more but I still get a pop up window asking me to enter the key.

I must be missing something

 

[Remou]

Is Key included as a field in the report?

 

[hext2003]

yes it is

 

[hext2003]

Do I need to add another field record number or something that is NOT in the report?

 

[Remou]

No, I'm trying to figure out why it is not working. If you have a text field Key in a table which has been used to build a report and a control called Key on the form used to call the report, then
[tt]DoCmd.OpenReport stDocName, , , "Key='" & Me.Key & "'"[/tt]

Should work. The error you are getting usually means that a field is misnamed or missing.

 

[hext2003]

I have two Key fields in this form and report

P Key is the Parent Key
C Key is the Child Key

There is a many to one relationship between C_Key and P_Key

Do I need to have "[P_Key]='" & Me.Key & "'"

rather than just Key?

 

[Remou]

You need to have whatever the key is called in the report data, be that Key, P_Key or C_Key.

What you are saying is:
[tt][blue]DoCmd.OpenReport stDocName[/blue]
Open a report ...
[blue], , , "Key='" [/blue]
That has a text field called Key as part of its RecordSource ...
[blue] & Me.Key & "'"[/blue]
That matches a control on my form called Key.[/tt]

 

[hext2003]

yep this is what I have

hmmmm

Do I need to remove the Criteria from the Query?

Thank you sooo much for your help, I'm just about ready to give up on this one.

 

[Remou]

Can you post the SQL for the report?

There is another possibility, which is to edit the query that the report is based on to include a reference to your form. You would put something like:

[tt]Forms![Form Name]!Key[/tt]

In the Key column of the query on the Criteria row.