Wow, dude! You are amazing! It works! I have been trying everything I know about Access for months now to figure this one out! Wait until my boss hears this! Yeah! Thanks again,
Doreen --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Once the form is open, Access 'remembers' the last field that had the focus > in the subform. If the user goes to a new row in the outer form, enters a > record, and then tabs forward, when the cursor moves into the subform, it'll > fall on the control that had the focus for the last outer record - not > necessarily the "first" control in the tab order. You could perhaps use the > Enter event of the subform control on the outer form to always set the focus > to the "first" control in the subform. > > John Viescas, author > Building Microsoft Access Applications > Microsoft Office Access 2003 Inside Out > Running Microsoft Access 2000 > SQL Queries for Mere Mortals > http://www.viescas.com/ > (Paris, France) > For the inside scoop on Access 2007, see: > http://blogs.msdn.com/access/ > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of rokkeee > Sent: Friday, June 16, 2006 9:23 PM > To: [email protected] > Subject: [ms_access] Re: subform tabbing problem > > > > No. There are only two fields linking the child and master. And > frankly, I just finished testing with multiple users whereby > everyone gets different results as to where the tab key puts you in > the subform. > > --- In [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com, > "John Viescas" <JohnV@> wrote: > > > > Doreen- > > > > Do you have any code in the form that's in the subform control? > > > > John Viescas, author > > Building Microsoft Access Applications > > Microsoft Office Access 2003 Inside Out > > Running Microsoft Access 2000 > > SQL Queries for Mere Mortals > > http://www.viescas. <http://www.viescas.com/> com/ > > (Paris, France) > > For the inside scoop on Access 2007, see: > > http://blogs. <http://blogs.msdn.com/access/> msdn.com/access/ > > > > _____ > > > > From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] > On Behalf > > Of rokkeee > > Sent: Friday, June 16, 2006 6:39 PM > > To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com > > Subject: [ms_access] subform tabbing problem > > > > > > > > I have a NewCustomer form with a subform where records are entered > > directly into a table. When adding the first new customer the tab > key > > works correctly as you maneuver through the form and the subform. > BUT > > for the second, third, etc. customers being added, when I tab into > the > > subform, the cursor in the goes directly to the last field and not > the > > first subform field as it should to make data entry more smooth. > > The tab order on the main form and the subform coincide with the > > fields I want to have updated in the table. What's making the > cursor > > jump to the third field in the subform and not go to the first as > with > > the initial New Customer? > > > > Doreen > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/6pRQfA/fOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
