Connecting Tech Pros Worldwide Help | Site Map

Syntax Error (Missing Operator)

  #1  
Old April 2nd, 2009, 10:54 PM
Newbie
 
Join Date: Nov 2008
Posts: 26
Hi All,

Can you please check what I am missing here
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "saidhazard2", , , "[FK_SAIID] = " & Me!SAIID & "[FK_Haz_Cat_ID] = " & Me!FK_HazCatID
Thank you for your help.
  #2  
Old April 2nd, 2009, 11:02 PM
Newbie
 
Join Date: Nov 2008
Posts: 26

re: Syntax Error (Missing Operator)


I got what I was missing.

Thank you.
  #3  
Old April 3rd, 2009, 07:46 AM
nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
Provided Answers: 1

re: Syntax Error (Missing Operator)


Please post the solution the next time:
"[FK_Haz_Cat_ID] = "
should be:
" AND [FK_Haz_Cat_ID] = "

Nic;o)
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax Error Missing Operator access baby answers 3 April 20th, 2007 07:05 PM
Syntax error (missing operator) in query expression isaac2004 answers 2 February 21st, 2006 11:55 PM
Syntax Error (Missing Operator) in query expression khan answers 4 November 13th, 2005 10:31 AM
80040e14 Syntax Error (missing operator) Alan Murrell answers 1 November 12th, 2005 02:29 PM
Syntax error (missing operator) in query expression shank answers 29 July 19th, 2005 02:37 PM