Automate a checkbox

S

Sue

I have several data entry forms in a database. When I enter data in one
particular form, I want a certain checkbox on that form to be automatically
checked.
Can do?
Thanks.
 
K

Klatuu

The brevity of my previous post matched that you your question.
More info gets better answer.
 
S

Sue

I mean that when any data gets entered in any field of that form, I want a
checkbox that is on that form to be checked.
 
K

Klatuu

Me.ChecBoxName = True

Just use the actual name of the check box and put this code in the After
Update of every control on the form where you enter any data.

If you have any code that performs an Undo on the form, you will want to
change it to False after the Undo.
 
M

missinglinq via AccessMonster.com

Hey, Sue!

Since the first time information is entered into any control on a form is
when the record is a new record, why not:

Private Sub Form_Current()
If Me.NewRecord Then
YourCheckBoxName = True
End If
End Sub
 
S

Sue

Duh.
I set the default on the checkbox for this form to "yes". This is the only
form where I enter this particular information. I think I was making things
way too complicated.
Thanks, everyone.
 
Top