Hey everyone. Does anyone know the correct verbage for referencing a subform?

Trying to do it from a public module and its not wanting to work itself out.

The subform feeds a list of groups that the main form record relates to. The module updates the list, as there are a couple of unique instances in the Database.

If I type out the full path "Forms!frmExerciseManager!fSubExerciseMuscleGroups.SetFocus", it works just fine. However, since I am doing this from a public module, to serve several different instances, it kind of defeats the purpose of making the module to begin with.

I have tried assigning form variables, variants, even strings and Forms([Form Name String]).Form.

Every combination of this throws one of about 4 different run-time errors. Any Ideas?

---

Reply from Alex Hedley:

Me.[SubformName].Form.[ControlName]

Forms![FormName].[SubformName].Form.[ControlName]
Forms("FormName").[SubformName].Form.[ControlName]
Form_FormName.[SubformName].Form.[ControlName]

Me.[SubformName]![ControlName]
Forms![FormName].[SubformName]![ControlName]
Forms("FormName").[SubformName]![ControlName]
Form_FormName.[SubformName]![ControlName]

Me.[qryReviewJobs Subform]![txtJobNumber]
Me.[qryReviewJobs Subform].Form.txtJobNumber
Forms![frmFieldServiceDatabase].[qryReviewJobs Subform]![txtJobNumber]
Forms("frmFieldServiceDatabase").[qryReviewJobs Subform]![txtJobNumber]
Form_frmFieldServiceDatabase.[qryReviewJobs Subform]![txtJobNumber]

From: Referring to Items on a Sub-Form