Subform ?

T

teelee

I have a form and a subform what I want to happen is when I finish entering
in the last field on the subform I want it to go to the first part of the
form and the subform to change for a new record.


Thanks
 
T

tina

if you will only ever enter one subform record for each mainform record, in
a given session, you can add code to the last editable control in the
subform's TabOrder, to move the focus back to a mainform control. as for
"...and the subform to change for a new record" - i don't get what you mean
here. if you're moving to a *new* record in the main form, the subform will
also automatically move to a new record (unless the subform's AllowAdditions
property is set to No).

hth
 
T

teelee

After I enter the data into the last field in my subform I need it to go to
the first field in my mainform.

Thanks
 
T

tina

yes, i understood that from your first post, but i've no answer to give you
other than the one i already posted.
 
Top