 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2007Automate a checkbox
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. Yes  SignatureDave Hargis, Microsoft Access MVP > 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. SignatureDave Hargis, Microsoft Access MVP > 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. 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. > The brevity of my previous post matched that you your question. > More info gets better answer. [quoted text clipped - 5 lines] >> Can do? >> Thanks. 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. SignatureDave Hargis, Microsoft Access MVP > 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. [quoted text clipped - 8 lines] > >> Can do? > >> Thanks. Thanks but that didn't do it. Ah well! SignatureThanks for your time! > Me.ChecBoxName = True > [quoted text clipped - 16 lines] > > >> Can do? > > >> Thanks. 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 SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 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. SignatureThanks for your time! > Hey, Sue! > [quoted text clipped - 6 lines] > End If > End Sub |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.