Access Database

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

Guest

In a form how can i get a particular field to equal '1' only when a check box
is true?? If the check box is not true - can I enter a specific value or
will it have to equal a set value?
 
In the AfterUpdate event of the checkbox, you'd use something like:

If Me!chkMyCheckbox = True Then
Me!txtMyParticularTextControl = 1
Else
Me!txtMyParticularTextControl = 2
End If

If you want to input a value instead of using the "canned" value "2", check
Access HELP for the Input() function.
 
Back
Top