DoCmd.OpenReport

G

Gina K

Can someone please help me get the " and ' right for this? (PARTNUMBER is a
text field). I just can't get it...argh!

DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =" ' "&
Me.PARTNUMBER" ' "
 
D

Duane Hookom

DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =""" &
Me.PARTNUMBER & """"
 
B

Boyd Trimmell aka Hi Tech Coach via AccessMonster.

You have an extra " right after the = and need a & after Me.PARTNUMBER

Try:
DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] = ' "& Me.PARTNUMBER
& " ' "


Gina said:
Can someone please help me get the " and ' right for this? (PARTNUMBER is a
text field). I just can't get it...argh!

DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =" ' "&
Me.PARTNUMBER" ' "
Click to expand...
 
Top