Checking for a null value

[illy2k]

Ok here is my code snipet:

With rst
.Find "[AccountNum] = #" & Me.AccountNum & "# "
If .Fields("SubAccount") = Null Then
Exit Sub
End If

I just want to see if the value in the field of the recordset rst, has nothing entered for it. For example if on the form the account# is 2, and in the table account# 2 has no subaccount I want it to exit the sub routine. However this doesn't happen. Any Ideas?

 

[pbaldy]

Try

If IsNull(.Fields("SubAccount")) Then