Tabbing Between Main Form and Subform

[fitzgeraldwm]

Hope someone has an solution to what appears to be an easy fix...

I have a main form with 3 subforms within it. I enter data on the main form and then tab into to the first subform, enter data, no problem. Here is where my problem is. I want to tab to the next subform and enter data there and then proceed to subform2, etc. i would like not to have to put special instructions to users to CTRL + TAB at the bottom of each subform. i have apparently linked the files correctly because navigating with the mouse data, has been entered successfully.

Any ideas? Thanks to all the gurus for the forum answers as the helps are incredibly useful!

wally fitzgerald
wmf@u.washington.edu

 

[jgoodman00]

Access does not as default tab out of subforms, it merely enters a new record.
To correct this you need to write some code in the last control of the subform, & place it in the after_update event. It needs to set the focus to the first control in the subform... James Goodman