Automate a checkbox

  • Thread starter Thread starter Sue
  • Start date Start date
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.
 
The brevity of my previous post matched that you your question.
More info gets better answer.
 
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.
 
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.
 
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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
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.
 
Back
Top