Setting a check box = True if...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following code, meant to set a check box is producing a Run-Time error
424 - Object Required.

Private Sub Date_Spect_Doc_in_Livelink_AfterUpdate()
If Me![date Spect Doc in Livelink] Is Not Null Then
Me!In_Livelink = "true"
Else
Me!In_Livelink = "False"
End If
End Sub

Thanks
 
Remove the quotes around true and false - the quotes makes it a string
rather than a Boolean value.
 
Rafi,

Moreover, if the value of your boolean field is determined by the value in
another field, you don't need it in your table, and the table will not be
fully normalized if you do. Simply calculate it "on the fly" in a query.

Sprinks
 
Back
Top