![]() |
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
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
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" wrote in message ... 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. |
#3
|
|||
|
|||
![]()
"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/For...forms/201006/1 |
#4
|
|||
|
|||
![]()
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" wrote in message ... 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. . |
#5
|
|||
|
|||
![]()
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/For...forms/201006/1 . |
Thread Tools | |
Display Modes | |
|
|