strange semicolon error message

[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

 

[Stefan Hoffmann]

hi,

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

Try [Bid].[BidNumber]... also it seems that you have one extra closing
bracket.

mfG
--> stefan <--

 

[Slez via AccessMonster.com]

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

hi,

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

Try [Bid].[BidNumber]... also it seems that you have one extra closing
bracket.

mfG
--> stefan <--