Variable Control Name

[xolo]

How do I use SetFocus to a control with variable name from another form?

 

[Khalid_Afridi]

you have to use the goto control method on that form and then use the setfocus method. if its subform; then you have to use the full path of the form.
for example:
DoCmd.GoToControl "yourForm"
Forms!formname!subformname!controlname.Setfocus

 

[boblarson]

Or if using a variable for the form name and control name you can use:

Forms(formVariableHere).Controls(ControlVariableHere).SetFocus

 

[xolo]

Thanks! My problem was to find the right syntax to call the VARIABLE name. Now that should help me, I will give a try!