Arthur Fuller
artful at rogers.com
Sun Sep 4 11:20:42 CDT 2005
It seems I cannot recall how you refer to a control on a subform. I want to do a couple of different things. In each case, assume that the code is in the parent form's module. a) set focus to a control on the subform With Me .subformName.Form.ControlName.SetFocus 'is this how? End With b) call a procedure in the subform's module... I assume I have to change it from a Private to a Public sub, but what syntax do I use to call the sub from outside? Is it With Me Call .subformName.ProcedureName End With c) set a control's value in the subform to a specified value. Is it With Me .subformName.Form.ControlName = 12345 End With TIA, Arthur