strange semicolon error message

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

Slez via AccessMonster.com

When I try to run a forms code, I get an error message that states: MIssing
semicolon (;) at the end of SQL statement.

While this seems to be blatently obvious, the strange part is that I DO have
a semicolon at the end of my SQL statement. Here is the very end of the
statement.

...AND ((Bid.BidNumber)=[Forms]![frmCopyBid]![ExistingBidNumber]));"

Any idea what might be the cause of an error like this? It does not debug
and highlight the affected area, so I'm unable to confirm this is the actual
problem area.
Any suggestions are appreciated!
Slez
 
hi,
..AND ((Bid.BidNumber)=[Forms]![frmCopyBid]![ExistingBidNumber]));"
Click to expand...
Try [Bid].[BidNumber]... also it seems that you have one extra closing
bracket.

mfG
--> stefan <--
 
Thanks for the reply! Adding the brackets didn't help, but after further
review, I found an error earlier in my SQL string.
Slez


Stefan said:
hi,
..AND ((Bid.BidNumber)=[Forms]![frmCopyBid]![ExistingBidNumber]));"
Click to expand...
Try [Bid].[BidNumber]... also it seems that you have one extra closing
bracket.

mfG
--> stefan <--
Click to expand...
 
Back
Top