If blank field

The code needs to be changed to this:

Code:
Private Sub Check72_AfterUpdate()
  If Not IsNull(Me.Check72) And IsNull(Me.[King Charge]) Then
        Me.[King Charge] = 55
  End If
End Sub


And here's the attachment.

Remember when we ask for names for the code it is USUALLY the CONTROL names we want NOT the field names.
 

Attachments

It works just fine ... Thank You ... THANK YOU ...
O! Did I say Thank You So Much.
 
Glad we finally got it figured out. Good luck with the rest of it. :)
 

Users who are viewing this thread

Back
Top Bottom