how to move to a control on a subform ?

[hessleroader]

Hi all,

I have the following forms below

main form is call "Inward" with a field called "RMA"

Also in the form I have a Subform called "InwardSubform"
with a field called "SUNo"

I am trying to create after update event of the RMA field on main form to then goto SUNo on the subform ?

Many thanks

 

[Ranman256]

me.subform.form.textbox.setfocus

 

[hessleroader]

Me.Inwardsubform.Inward.SuNo.SetFocus
also tried

Me.Inward.InwardSunform.SuNo.SetFocus

tried this but getting member not found

Thanks

 

[JHB]

Try: First set the focus to the subform, then afterwards to the control in the subform.

 

[missinglinq]

JHB's approach is the correct one.

 

[CJ_London]

you have misinterpreted Ranmans's solution - you need

Me.Inwardsubform.form.SuNo.SetFocus

see this link about referring to controls in other forms

http://access.mvps.org/access/forms/frm0031.htm

 

[JHB]

When you set the focus direct you'll not see the cursor in that control, (even if it has got focus).
If you set the focus via the subform, the cursor is "blinking" in the control.
Sample database attached.