tab out subform01 to subform02

[beppe005]

I have a form with 3 subforms (linked, the prevois to the next) which are
continuous forms, I wonder whether it is possible to move automathically the
cursor from one subform to the next when I finish entering the data instead
of using ctrl+tab.

subform01: I have 2 fields (date, import), after entering them I'd like the
cursor to go to subform02 (and so on)
subform02: I have one field (date of job)
subform03: I have 3 fields (hours, extra hours...)

Thanks in advance
Beps

[Larry Linson]

The Control's AfterUpdate event should fire when you complete entering the
data in that control. By using a fully qualified reference to the next
subform and control, you should be able to do something like this
(substitute the name of your Subform Control for S2 and the name of the
control on the Form embedded in that Subform Control for C2). If that
doesn't work, you may be able to make it work by first doing a
DoCmd.RunCommand acCmdSaveRecord :

Me!Parent!<S2>.Form!<C2>.SetFocus

Larry Linson
Microsoft Access MVP

"beppe005" <be**************@virgilio.it> wrote in message
news:i6*********************@news3.tin.it...

I have a form with 3 subforms (linked, the prevois to the next) which are
continuous forms, I wonder whether it is possible to move automathically the cursor from one subform to the next when I finish entering the data instead of using ctrl+tab.

subform01: I have 2 fields (date, import), after entering them I'd like the cursor to go to subform02 (and so on)
subform02: I have one field (date of job)
subform03: I have 3 fields (hours, extra hours...)

Thanks in advance
Beps