Set Focus In Subform

J

Jeanette Cunningham

Hi Jone,

me.[name of your subform].setfocus
Me.[name of your subform].form.[name of control on your subform].setfocus

The name of your subform is different from the name of the form inside your
subform.
Look on the form's property sheet to see the name of your subform.

Jeanette Cunningham
 
B

boblarson

Just a clarification as this statement:

"The name of your subform is different from the name of the form inside your
subform."

was a little confusing. The name of the Subform CONTAINER (or Control) is
the name you use. It is the control that HOUSES the subform on the main form.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________
 
Top