Tab Order & form sections

[Randy K.]

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

 

[Stewart Tanner]

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.]

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