Set focus to subform field

[gojets1721]

I'm trying to set the focus to a subform's field from the parent form, but I can't seem to get it working. Here's what I tried via VBA:

Me!subform1.Form!txtsubformfield.SetFocus

Any suggestions

 

[CJ_London]

set the focus to the subform first

 

[ebs17]

SetFocus is very popular, but I hardly ever use it. The object reference used is sufficient to transfer a value or accept a value.

 

[LarryE]

I'm trying to set the focus to a subform's field from the parent form, but I can't seem to get it working. Here's what I tried via VBA:

Me!subform1.Form!txtsubformfield.SetFocus

Any suggestions

Me.SubForm1.Form.Controls("SubForm field name here").SetFocus
might work.

 

[arnelgp]

[Forms]![MainFormName]![subform1].SetFocus
[Forms]![MainFormName]![subform1].Form![subformfield].SetFocus

 

[gojets1721]

[Forms]![MainFormName]![subform1].SetFocus
[Forms]![MainFormName]![subform1].Form![subformfield].SetFocus

Thank you all! This worked