From: Rosco on 4 Jun 2010 09:33 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 4 Jun 2010 18:30 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 4 Jun 2010 19:54 "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 7 Jun 2010 11:11 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 7 Jun 2010 11:11 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 > > . >
|
Pages: 1 Prev: Need from to replicate itself as a blank for each time it is o Next: Imported Form Changes |