Setting a check box = True if...

R

Rafi

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
 
S

SusanV

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

Sprinks

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
 
Top