 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Using Check Boxes in a form
Hi, I would like to use OnEnter to place the check in a check box and then be able to tab to the next feild on my form but I currently have the Keyboard option to go to a new record OnEnter. Is there a way to do both? Any other ways to go about it? Thanks in advance, Sara Sara, I am sorry I cann't answer but have the same question. I want to have a check box on a subform where I can create entry to another table. Var > Hi, > I would like to use OnEnter to place the check in a check box and then be [quoted text clipped - 4 lines] > Thanks in advance, > Sara Sarah, I have the same problem. I want to select options from a list using a check box and link that to a adding a new employee record in another table. Any thoughts? Varvara > Hi, > I would like to use OnEnter to place the check in a check box and then be [quoted text clipped - 4 lines] > Thanks in advance, > Sara Sorry I wish I could help but I'm stumped. Sara > Sarah, > I have the same problem. I want to select options from a list using a check [quoted text clipped - 10 lines] > > Thanks in advance, > > Sara Try this: Place a check box on the form. In design view, scroll down to the OnEnter row, select Event Procedure and click elipsis to the right of Event Procedure. This will open up VB and type: Me!"Name of check box" = -1 This will place a check box in the box on entry; NO quotes arond name of check box THEN Go back and select Event Procedure on the AfterUpdate row, enter VB and type DoCmd.GoToControl "name of field you want to go to" Leave the quotes around the name of field. This will move the control to your selected field after the check box is filled. > Hi, > I would like to use OnEnter to place the check in a check box and then be [quoted text clipped - 4 lines] > Thanks in advance, > Sara Hi, That sort of worked and it makes sense but what happens is that I only want to use enter to indicate that a certain item has been submitted and be able to leave it blank if it wasn't. Also as soon as I use the enter cmd it pops me to the next record and the next field which I'm trying to get it to just go to the next field in the same record. Any ideas? Thanks, Sara > Try this: Place a check box on the form. In design view, scroll down to the > OnEnter row, select Event Procedure and click elipsis to the right of Event [quoted text clipped - 22 lines] > > Thanks in advance, > > Sara Sara, I think you are somewhat confused. OnEnter refers to the cursor as it enters that field (Event shall occur), NOT when you press Enter on the keyboard. You should be using the Tab key to move between fields and the Spacebar to fill the Checkbox. If this makes sense, let me know and I can probably give you some help. I think you want to place a check in your checkbox as you tab into or click that box, and have ir move automatically to the next field. hd > Hi, > [quoted text clipped - 33 lines] > > > Thanks in advance, > > > Sara Hi, That's exactly it but now things are really making sense and yes I would like to have to use the spacebar to enter the check in the checkbox. Right now with the code you've given me it automatically places a check in the box and sends me back to VB when I try to remove it, so......how do I change that? Thanks again for your help. Sara > Sara, > [quoted text clipped - 45 lines] > > > > Thanks in advance, > > > > Sara Let's start over; Place the checkbox on the form in design view, and in the properties menu select After Update; enter Vb and type the following SendKeys "{TAB}", False when you enter the checkbox, hit the spacebar, the check will appear and then the cursor will move to the next field. That field can be changed by selecting the proper order in the Tab Order on the View Menu toolbar inside Design View of the form. > Hi, > That's exactly it but now things are really making sense and yes I would [quoted text clipped - 55 lines] > > > > > Thanks in advance, > > > > > Sara Hi, Well I guess this is one way to learn.... that worked perfectly! Thank you again for all your help it's been brilliant! Regards, Sara > Let's start over; Place the checkbox on the form in design view, and in the > properties menu select After Update; enter Vb and type the following [quoted text clipped - 64 lines] > > > > > > Thanks in advance, > > > > > > Sara |
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.