Command button to move to subform

[Donna]

I have a form with job information. This form takes up the entire screen.
for ease of entry, I wanted the user to be able to just hit a command button
when ready to move to the subform to enter the line items needed for the job.

I can't figure out how to program the button to jump to the first field in
the subform. Is there a way to do that?

 

[BruceM]

If the name of the subform control is fsubDetails, something like this in
the command button's Click event:
Me.fsubDetails.SetFocus
The cursor should go to the first control in the subform's tab order.
If you are not sure of the subform control name, in design view click the
very edge of the subform so that little rectangles show up at the corners
and in the middle of each edge, then click View > Properties.

 

[Donna]

PERFECT! Thanks.

If the name of the subform control is fsubDetails, something like this in
the command button's Click event:
Me.fsubDetails.SetFocus
The cursor should go to the first control in the subform's tab order.
If you are not sure of the subform control name, in design view click the
very edge of the subform so that little rectangles show up at the corners
and in the middle of each edge, then click View > Properties.

 

[BruceM]

Glad to help.

PERFECT! Thanks.