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
|
|||
|
|||
Tab Order & form sections
I have a form with controls in both the detail and footer section. The form
is set to continuous forms and when the form is opened, focus starts with an item in the detail section and when the user tabs through, it moves through the 1 or more detail records until it reaches the last control of the last detail record. From there, it moves to the first control of the last record, and I WANT it to move to the first control of the footer section. What do I need to do/set to have it behave as I/the users want it to? TIA, Randy |
#2
|
|||
|
|||
Tab Order & form sections
in the oncurrent event of the form do something like this
if me.newrecord then me.control.setfocus end if where control is the name of the first control in the footer. "Randy K." wrote in message ... I have a form with controls in both the detail and footer section. The form is set to continuous forms and when the form is opened, focus starts with an item in the detail section and when the user tabs through, it moves through the 1 or more detail records until it reaches the last control of the last detail record. From there, it moves to the first control of the last record, and I WANT it to move to the first control of the footer section. What do I need to do/set to have it behave as I/the users want it to? TIA, Randy |
#3
|
|||
|
|||
The subform doesn't allow new records.
It only shows the records returned from a query so it just cycles on the last record so I don't know what to check for with that method. TIA, Randy "Stewart Tanner" wrote in message ... in the oncurrent event of the form do something like this if me.newrecord then me.control.setfocus end if where control is the name of the first control in the footer. "Randy K." wrote in message ... I have a form with controls in both the detail and footer section. The form is set to continuous forms and when the form is opened, focus starts with an item in the detail section and when the user tabs through, it moves through the 1 or more detail records until it reaches the last control of the last detail record. From there, it moves to the first control of the last record, and I WANT it to move to the first control of the footer section. What do I need to do/set to have it behave as I/the users want it to? TIA, Randy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need help with joining table for an order form to be based on | Arleta | General Discussion | 5 | October 5th, 2004 04:33 PM |
Default values to load up automatically in a form based on value entered in another form | Anthony Dowd | Using Forms | 8 | August 12th, 2004 08:53 AM |
Data Dependencies between Combo Boxes | Tom | Using Forms | 7 | June 6th, 2004 05:25 PM |
Problem adding a command button to a form in order to open another form | Janice | New Users | 2 | May 10th, 2004 11:31 PM |
Order form | Jamie | Worksheet Functions | 1 | September 16th, 2003 11:02 PM |