New Record, Invalid Use of Null

  • Thread starter Thread starter sofiac
  • Start date Start date
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!
 
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

Invalid use of Null 3
Run-Time Error '94' Invalid use of Null 9
Runtime Error 94 when entering a new record 2
Object Variable Error 7
.VISIBLE Not Working Perfectly 2
Invalid Use of Null 3
Locking a record via a form 2
popup issue if no existing record 1

Back
Top