Controls in forms and subforms

[donnan33]

I have a form. it has a main form and 2 sub forms. on data entry i need to be able to enter data on main form then it on enter it goes to first field of first subform which is great. then on last field of first subform it will not go to first field of next subform. it keeps going to back to first fireld of same form not to next sub form. how can i get it to go after tab or entry to first field of next subform?

[Robeen]

You can use the information on this page:
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
. . . to help you to force the focus to go to the next sub form.

For instance, you can put VBA code in the 'On Lost Focus' Event of the last field on your first sub form telling Access that when you leave that field, you want the focus to go to the first field of the second sub form.

Your code in that event might look something like this:

Forms!MainForm.SecondSubForm!FirstFieldOnSecondSubForm.SetFocus

I hope this helps!

[donnan33]

Thank you for your help.