Re: Referencing a field in a subform

On my website (www.rogersaccesslibrary.com), is a small sample database
called "SubformReference.mdb" which illustrates this and other problems with
referencing subforms and subsubforms. It also explains how referencing
works.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

"JohnB" <JohnB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18AC072C-3554-4A06-852D-E45F57399D45@xxxxxxxxxxxxxxxx
> Hi.
>
> I have a command button on the bottom of a form and I need to be able to
> modify the code in it to reference a combo in the forms subform. The
trouble
> is, the main form is itself a subform on a Tab Control and I can't get it
to
> work. Here's the detail - sorry it's a bit complicated:
>
> The main forms Subform Control Name on the Tab page is frmSECMentors.
> The Source Object (the form name) is also frmSECMentors.
> The main form has a subform whose Subform Control Name is
SubSECMentorSchool.
> The Source Object (subform name) is frmSECMentorSchoolSubform.
> The combo on the subform is called cboMentor School.
>
> I want to check if cboMentorSchool has content, using If Not IsNull
> (......). Can anyone help me reference cboMentorSchool?
>
> Thanks, JohnB
>
>


.

Loading