Tab Order

[Rosco]

In Access 2003, I have a continuous form, with several text boxes, 4 of which
are user editable, and 4 check boxes. Everything works as it is supposes to,
except when I tab through a record, if a change is made in either a check box
or text box, when tab is pressed again, the focus goes to the first field of
the first record, rather than the next field in the current record, or in the
case of the last field of a record, the next record, as I would expect.

It's probably a simple setting I'm missing, but I've not run into this issue
before, so any thoughts are appreciated.

 

[Jeanette Cunningham]

What settings do you have for tab stops for each textbox and checkbox?
What is the tab order for the form's detail section?
Do you have the form's cycle property set to All Records or Current Record?
Do you have any code that sets focus to any textbox or checkbox?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Rosco]

Hi Jeannete,
Thanks for the response.
1. Tab stop Yes on the 6 controls that are editable no on the rest
2. Tab Index=0-5
3. Tab Order reflects the Tab Index
4. Cycle property set to All records
5. No,there is no set focus code.

 

[Rosco]

Bingo. You nailed it. I have me.requery code in each of the after update
event of the 6 editable controls.

Thanks