Setfocus on a control on a subform

B

Brigham Siton

Great. Thank you very much.

Brigham

chas said:
Hi Brigham,

I think you need to use the full path to the control on
the subform. Something like:

Forms![Orders]![Orders Subform].Form![UnitPrice].SetFocus

hth

chas
-----Original Message-----
How do I setfocus on a control in a subform from the main form?

Thank you.


.
Click to expand...
Click to expand...
 
K

Ken Snell

First set focus on the subform control (the control on the main form that
holds the subform). Then set focus on the control in the subform. You need
to do this in two steps.

Me.subform.SetFocus
Me.subform!control.SetFocus
 

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

Trying to remove error from conflicting code 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Tab to subform 3
DLookup in Continuous form 0
A On Open problem 5
Looping until end. 2
Populate main form from subform record 0
Using a subform to show newrecord on the main form 1

Top