New Record, Invalid Use of Null

[sofiac]

I am unable to add a new record and get the error message "Invalid Use of
Null". I have an event procedure which reads:

Private Sub Form_Current()
If Me.[AutoRenew] Then
Me.[Review].Visible = True
Else
Me.[Review].Visible = False
End If

Can you tell me where my error may occur? This doesn't occur when I am
editing an existing record. Thank you!

 

[Douglas J. Steele]

Try

If Nz(Me.[AutoRenew], False) Then
Me.[Review].Visible = True
Else
Me.[Review].Visible = False
End If

 

[Gina Whipp]

Sofiac,

What is AutoRenew? Is it a True/False field which is Null?