syntax help on rs.findfirst

[tanzania]

Hi, I need some syntax help on the following line of code:

rs.FindFirst (rs![NewRecord] = True And IsNull(rs![Event_No]))

where NewRecord is type boolean and Event_No is string. Ive used this function mainly on strings so am not sure what to do with this one!
thanks!!

 

[ajetrumpet]

Change:

rs.FindFirst (rs![NewRecord] = True And IsNull(rs![Event_No]))

To this:

rs.FindFirst (rs![NewRecord] = True And rs![Event_No] = NULL)

 

[tanzania]

...didnt work as i hoped but i havent pursued it anymore as i have found another way to solve my problem. thanks all the same, and will def go in the knowledge bank