print just one record from a form

[emzadi]

Ok, I want to cry.

I followed the instructions at this link:

http://www1.zdnet.com/pcmag/pctech/content/solutions/db1801a.htm

to print just one record from a form...

Everything was fine, then 10 minutes later, I started getting an "on click" error... "Procedure declaration does not match description of event or procedure having the same name."

Here is my code...

Private Sub cmdPrintForm_Click()
On Error GoTo Err_cmdPrintForm_Click

DoCmd.OpenReport "PrintForm2", acViewNormal, , "RegNumber=Forms!Main Screen!RegNumber"

Exit_cmdPrintForm_Click:
Exit Sub

Err_cmdPrintForm_Click:
MsgBox Err.Description
Resume Exit_cmdPrintForm_Click

End Sub

What have I done wrong?

Susan M. Wagner
LAPELS
susanw@lapels.com

 

[dneufarth]

"RegNumber=Forms!Main Screen!RegNumber" is suspect with space as part of form name.

Try "RegNumber=Forms![Main Screen]!RegNumber"


Dave