syntax error

[fabiobarreto10]

friends I have this code:



Set rs = Db.OpenRecordset("SELECT DataRealizada FROM TblPassosStatus WHERE CodProduto =" & CodProduto & " AND CodPassosStatus < " & CodPassosStatus & " AND DataRealizada =" & IsNull)


DataRealizada is null, but is not working. Displays a message: syntax error.

How do I fix?

Thank you.

[pbaldy]

Try

Set rs = Db.OpenRecordset("SELECT DataRealizada FROM TblPassosStatus WHERE CodProduto =" & CodProduto & " AND CodPassosStatus < " & CodPassosStatus & " AND DataRealizada Is Null")

[fabiobarreto10]

Perfect. pbaldy, thanks lots.

[pbaldy]

No problem.