select item in combo box then auto tab to subform

G

Green acres

I have a form and a sub form. I have a combo box where you select a item. Is
there a way to autotab after the selection?
 
K

Ken Snell \(MVP\)

You can use the GoToControl action in the After Update event of the combo
box. Note that you would need two such actions -- the first to set focus on
the subform control (the control that holds the subform source object), and
the second to go to the control in the subform (you must reference this
control through the subform).

Action: GoToControl
Control Name: < name of subform control >
(e.g., MySubform)

Action: GoToControl
Control Name: <name of subform control >!<name of control on subform>
(e.g,. MySubform!MyControlName)
 
G

Green acres

Thank you that helped!!

Ken Snell (MVP) said:
You can use the GoToControl action in the After Update event of the combo
box. Note that you would need two such actions -- the first to set focus on
the subform control (the control that holds the subform source object), and
the second to go to the control in the subform (you must reference this
control through the subform).

Action: GoToControl
Control Name: < name of subform control >
(e.g., MySubform)

Action: GoToControl
Control Name: <name of subform control >!<name of control on subform>
(e.g,. MySubform!MyControlName)
Click to expand...
 
Top