DoCmd.OpenReport

  • Thread starter Thread starter Gina K
  • Start date Start date
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" ' "
 
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...

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

Message posted via AccessMonster.com
 
Back
Top