Getting a Syntx error 3075

[tarena]

Error#: 3075

Extra ) in query expression '(numPartRecNo=) and (strClockNo IS NOT NULL)'.

Here is the code I have written;

"WHERE (numPartRecNo = " & Me.OpenArgs & ") and (strClockNo IS NOT NULL)" & _

Is this enough to find my mistake or do you need more?

 

[TonyJollans]

If I read correctly your mistake is that Me.OpenArgs is empty and the apparently odd message is a result of a missing comparand for numPartRecNo.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association