Perhaps you could add another tiny unbound text box to the end of the tab
order for the first subform. Use the Enter event of this control to jump to
where you want to go.
The event procedure code would need to:
- save any edits in progress
- set focus to the main form
- assign a value to the tab control (for the desired page)
- set focus to the next subform control
- set focus to the desired control within that form.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"BLW" <BLW[ at ]discussions.microsoft.com> wrote in message
news:42505AC4-4E68-4E9B-9B34-FE6D12BC3238[ at ]microsoft.com...
[Quoted Text] >I have a form (frmAssessments) with three subforms(sfrmAssess1,
>sfrmAssess2,
> sfrmAssess3). I want the user to enter data into the main form and then
> be
> able to tab to the fields of each subform and enter data.
>
> I got it to the point where they can tab to the first subform, but once
> you
> get to the last field of that subform - tab puts you back to the first
> field,
> new record.
>
> I have looked through the forum and tried several things from other
> questions without any luck.
>
> Any hlep you can give would be greatly appreciated.
|