Automatically check a checkbox

[sabavno]

Hi

I have table that has a field (yes/no)
I want to lookup that field and automatically check or uncheck the check box on the form.

Can that be done?

 

[jjonesal]

If the field is defined as a Yes/No field then when you add the field to the form, it will automatically be a checkbox (that's the default type for a Yes/No field).
J. Jones
jjones@cybrtyme.com

 

[petrosky]

Hi,

If you mean you want the check box to automatically check or uncheck based on a certain event...you can use an if, then statement something along these lines.


Private Sub Text2_AfterUpdate()
If Me.Text2 = "Peter" Then
Me.Check0 = True
Else:
Me.Check0 = False

End If


End Sub

HTH.

Peter Remember- It's nice to be important,
but it's important to be nice