From: Rosco on
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.
From: Jeanette Cunningham on
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" <Rosco(a)discussions.microsoft.com> wrote in message
news:8C4F43EB-F345-4F30-9940-A201C3B72D56(a)microsoft.com...
> 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.


From: Linq Adams via AccessMonster.com on
"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"

Unless this is some weird type of form corruption, it indicates that after
any control is changed the form is being requeried.

I'd go into the code module for the form and enter

Requiry

into the Find box and see what shows up.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201006/1

From: Rosco on
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.

"Jeanette Cunningham" wrote:

> 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" <Rosco(a)discussions.microsoft.com> wrote in message
> news:8C4F43EB-F345-4F30-9940-A201C3B72D56(a)microsoft.com...
> > 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.
>
>
> .
>
From: Rosco on
Bingo. You nailed it. I have me.requery code in each of the after update
event of the 6 editable controls.

Thanks

"Linq Adams via AccessMonster.com" wrote:

> "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"
>
> Unless this is some weird type of form corruption, it indicates that after
> any control is changed the form is being requeried.
>
> I'd go into the code module for the form and enter
>
> Requiry
>
> into the Find box and see what shows up.
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201006/1
>
> .
>