Janet Erbach
jerbach at gmail.com
Tue Apr 17 11:50:35 CDT 2012
Arthur - If it's the same as Access 2003 it would be something like this, I believe: Forms!ParentForm_Name!Subform_Name.Form.Controlname - gives you the value of a control on the subform Forms!ParentForm_Name.Controlname - gives you the value of a control on the parent form IF it's the same as Access 2003, that is! Janet Erbach On Tue, Apr 17, 2012 at 11:38 AM, Arthur Fuller <fuller.artful at gmail.com>wrote: > Actually I need to do it both ways. > > On the subform I need to refer to the value of a control on the parent > form. > On the parent form I need to set the recordsource of the subform. > > I've forgotten the Access 2000 (SP3) syntax. > > TIA, > -- > Arthur > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >