Print Report of Current Record in form

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I have command button OnClick has event procedure of code
below. Just want the current record to print using the
Report. When I click the button, it asks for Parameter
Value... what am I doing wrong?

Dim strDocName As String
strDocName = "Spec Sheet"
DoCmd.OpenReport strDocName, acViewNormal, , "KitID = " &
Me.KitID

Hope someone can help me!
 
Try this:
DoCmd.OpenReport strDocName, acViewNormal, , "[KitID] =
Forms![YourFormName]![KitID]"
or maybe its just the quotes....
Damon
 
Back
Top