Checkbox Value?

RichGags

Registered User.
Local time
Today, 14:58
Joined
Jun 30, 2003
Messages
39
Is it possible for a checkbox to get its initial value from a field?

I have a field that tells me if someone is interested in our services. When the form loads I would like the check box to check if the field says "Yes".

How would I do this?
Something like this?

Private Sub Form_Current()
If Me.Interested = "Yes" then
Me.Checkbox389 = TRUE
Else
Me.Checkbox389 = FALSE
End Sub

Thanks.
 
Last edited:
How about...

Private Sub Form_Current()
If Me.Interested.value = -1 then
Me.Checkbox389.value = -1
Else
Me.Checkbox389.value = 0
End Sub

-1 = True/Yes
0 = False/No

But it depends on how you have the field formated.

HTH
 

Users who are viewing this thread

Back
Top Bottom