DoCmd.OpenReport "Report1", , , "SocialSecurity = " & Me!SocialSecurity
Report doesn't print.
Al
DoCmd.OpenReport "Report1", , , "SocialSecurity = " & Me!SocialSecurity
Report doesn't print.
Al
I would think the SS field woud be text so you need quotes:
DoCmd.OpenReport "Report1", , , "[SocialSecurity]= '" & Me!SocialSecurity & "'"
Rg you are a rockstar!!!
Thank you
Glad I could help. Thanks for marking the thread Solved.