Referencing a field in a subform

[JohnB]

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

 

[Roger Carlson]

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]

Thanks Roger.

I'll keep a copy of that handy. I've had a look and I'll be trying this out
tomorrow but, for now, can I assume that I treat the Tab Control as the top
level form? If so, I believe my reference would be:

Forms!TabCtrl1!frmSECMentors.Form!SubSECMentorSchool.Form!cboMentorSchool

Thanks again for the help. JohnB

 

[Roger Carlson]

Actually no. The tab control plays no part in referencing subforms.
Pretend the subform is sitting on the mainform itself.
Forms!frmSECMentors!SubSECMentorSchool.Form!cboMentorSchool

--
--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]

I've tried that now and got it to work fine, with your latest suggestion.

Thanks for the help.

JohnB