How to print only one record

[Mobile]

Hi I have been trying to print out only one record.

My Primary key: Primary key (Auto Numbered)
Form Name: Main Menu From2


Button Name: Print Record
Report Name: MOC Report1

The Code is typed:

DoCmd.OpenReport "MOC Report1", acViewNormal, , "[Primary key] = " & Forms!MainMenuForm2

When I created a button in the Form Design, I selected the "print record".
I would appreciate anyone's help.
Thank you!

[Mobile]

I also have tried this code below:

Private Sub cmdPrint_Click()
Dim strWhere As String

If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If

If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[Primary key] = " & Me.[Primary key]
DoCmd.OpenReport "MOC Report1", acViewPreview, , strWhere
End If
End Sub

But I'm getting this error massage:
"Run-time error '2465': Management of change application can't find the field '/1' referred to in your expression"

[rzw0wr]

Mobile, what happens when you try to create your report?
Do you get an error?

DoCmd.OpenReport "MOC Report1", acViewNormal, , "[Primary key] = " & Forms!MainMenuForm2

Forms!MainMenuForm2 needs the control that contains the ID (PK) to compare.

Example; Forms!MainForm!ComboBox1

Dale

[Mobile]

Hi Dale,

Thank you for your response.
I typed your code and gave me an error message:
Compile error: Type mismatch

I don't get error for the report part.

[rzw0wr]

Hi I have been trying to print out only one record.

My Primary key: Primary key (Auto Numbered)
Form Name: Main Menu From2
Button Name: Print Record
Report Name: MOC Report1

Let's start from the beginning.

No error.
I am assuming that you want to create a report that contains information about the current record on a form.

What happens when you try to create you report? I am assuming again that all records are returned.

From where are you trying to select an ID to create the report?

Dale

[Mobile]

by ID, do you mean Field Name from the table?

[rzw0wr]

ID usually means the PK or auotnumber of the record.

Dale

[Mobile]

the Record is identified by Primary Key with autonumber.
Am I understanding correctly??

[rzw0wr]

Yes you are.
Now Let's start from the beginning.

No error.
I am assuming that you want to create a report that contains information about the current record on a form.

What happens when you try to create you report? I am assuming again that all records are returned.

From where are you trying to select an ID to create the report?

Dale

[Mobile]

I created "MOC Report1" and connected the information by using "Add Existing Fields" icon.
When I type information into the Form, it will appear to the Report also.

[rzw0wr]

On your form, you need to have the ID of the record(s) you want to have on the report.
We need someway of identifying the record(s) for the report.

Can you upload the database?

Dale