Problem in FindFirst

[arunakumari02]

I am getting an error

Syntax error in date expression

   rstDemanded.FindFirst "[Month]=#" & Forms!frmProject("txtMonth" & intMonth) & _
 "# AND [ID] =" & Forms!frmProject("txtRID" & intRow) & "AND [PID] =" & labPID

Any help

 

[georgedwilkinson]

Just a casual glance and I noticed a couple of things:
1. Never, ever, ever, name an object "Month".
2. What is "intMonth"? That just doesn't look like good syntax (I could be wrong).

You haven't really given us much to go on.

What do you get in the immediate window when you put this before the statement in question:

Debug.Print "[Month]=#" & Forms!frmProject("txtMonth" & intMonth) & _
 "# AND [ID] =" & Forms!frmProject("txtRID" & intRow) & "AND [PID] =" & labPID

If that gives you an error, reduce it until it doesn't. Then add back in elements, troubleshooting them one at a time.

 

[Brianwarnock]

You haven't really given us much to go on.

.

That's an understatement.

Brian