Setting a check box = True if...

[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

 

[Brian Bastl]

If Not IsNull(Me.[date Spect....] Then

Brian

 

[SusanV]

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

 

[Guest]

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