syntax help on rs.findfirst

[tania20]

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!!

 

[Remou]

How about:

[tt]rs.FindFirst "[NewRecord] = True And [Event_No] Is Null"[/tt]

 

[tania20]

thanks