If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Skip over several controls
I need to move forward about ten controls in my form if the answer to
question 1 is "No". Am using Access with XP. Thanks in advance! Tina. |
#2
|
|||
|
|||
Skip over several controls
Check the .SetFocus method in Access HELP.
Generically, you'd put code in the AfterUpdate event of the control for "question1" that set the focus to the "next" control. A simple IF...THEN... should suffice. -- Regards Jeff Boyce Office/Access MVP "1Tina" wrote in message news I need to move forward about ten controls in my form if the answer to question 1 is "No". Am using Access with XP. Thanks in advance! Tina. |
#3
|
|||
|
|||
Skip over several controls
Do you want the questions to be disabled, so that no one can answer them, or
simply move the cursor past those ten controls? I'm assuming question 1 is a check box. In its AfterUpdate event, for the first option, put code like: Me.Control1.Enabled = Me.chkQuestion1 Me.Control2.Enabled = Me.chkQuestion1 Me.Control3.Enabled = Me.chkQuestion1 ... Me.Control10.Enabled = Me.chkQuestion1 For the second option, put code like: If Me.chkQuestion1 Then Me.Control1.SetFocus Else Me.Control11.SetFocus End If -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "1Tina" wrote in message news I need to move forward about ten controls in my form if the answer to question 1 is "No". Am using Access with XP. Thanks in advance! Tina. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Q: "Grouping" controls / "locking" controls to background? | StargateFan | General Discussion | 3 | December 17th, 2005 03:58 AM |
Renmaing all controls on a form | SmilingPolitely | General Discussion | 1 | June 11th, 2005 01:10 AM |
Would like advice on resetting form controls after Undo | Jon A | Using Forms | 3 | February 14th, 2005 12:35 AM |
Maximum number of controls | ARG | Using Forms | 7 | January 30th, 2005 11:00 PM |
Problem with calculated controls with data from subforms | Ragnar Midtskogen | Using Forms | 8 | July 25th, 2004 07:18 PM |