Print a report of a Single Record from a Form

SerenityNet

Registered User.
Local time
Yesterday, 19:01
Joined
May 6, 2003
Messages
27
This is very similar to another post of the same name. However, my problem appears to be because the report includes data from both a form and a sub-form. I've received feedback before, but I'm still unable to get it to work.

I've placed a sample DB here. If someone could download the file, take a look, and show me what I need to do, then I would be very grateful. I've beat my head against the wall so long on this one, I can't even think anymore.

Thanks,
Andrew
 
Andrew,

You forgot the single-quotes.

Code:
DoCmd.OpenReport stDocName, acPreview, , "[FieldOne] = '" & Me![FieldOne] & "'"

Wayne
 
Thank you ! ! !

Thank you !
Thank you !!
Thank you !!!

Maybe one of these days I'll get the single and double quote logic down (but I doubt it).

Thanks again for the help,
Andrew

PS. I'm putting a fixed copy of the DB example at the hyperlink above, in case it will help someone else.
 

Users who are viewing this thread

Back
Top Bottom