New Record, Invalid Use of Null

S

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

Douglas J. Steele

Try

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
VSTO C# add in Outlook.Appointment error 0
Invalid use of Null 3
Run-Time Error '94' Invalid use of Null 9
Invalid Use of Null 3
Runtime Error 94 when entering a new record 2
Invalid SQL statement on rst.Open to same table in 'Current' event 2
'Invalid Argument' 2

Top