Print Help

[whjwilson]

I am trying to set up a button to print report that is currently open, this is what I have set for the click command code:

DoCmd.OpenReport "Weapons Cards", acViewNormal, , "Name = " & Forms!Main!Name

Whenever I click the button to print I get an error:

syntax error (missing operator)in query expression '(Name = William Wilson'

 

[PHV]

DoCmd.OpenReport "Weapons Cards", acViewNormal, , "Name = [tt]'" & Forms!Main!Name & "'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886