DoCmd.OpenReport

[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" ' "

 

[Duane Hookom]

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

 

[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
& " ' "

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" ' "

--
Boyd Trimmell
aka Hi Tech Coach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com