Reference controls on a subform

K

Ken Snell

You need two VBA code steps to do this, the first to set focus on the
control that holds the subform, the second to set focus on the control in
the subform:

Me.NameOfSubformControl.SetFocus
Me.NameOfSubformControl.Form.NameOfControlOnSubform.SetFocus

A macro action can be used instead if you want, using the SetFocus action.
But you still need two steps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
DLookup in Continuous form 0
Hide Controls on Subform 2
Referencing Subform Controls/Properties 2007 3
Subform control OnClick firing 1
Link subform ID control 3
Problem with form--subform 5
set focus to control on subform 0

Top