what is Syntax to reference subform field

[Joe]

I am trying to reference a field that is part of a subform from the main
form.

For example, I want to change the background color of a field on a subform
based on a command on the main form. So I want to do something like this:

MainForm!Subform_name.field_name.backcolor - 255

But I can't get the syntax right.

 

[Douglas J. Steele]

Forms![NameOfMainForm]![NameOfSubformControlOnMainForm].Form![NameOfControlOnSubform].BackColor
= 255

Note that depending on how you added the subform, the name of the subform
control on the parent form may be different than the name of the form being
used as a subform.

See http://www.mvps.org/access/forms/frm0031.htm at "The Access Web" for
more deatils.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to do this and a
number of other issues with referencing subforms and subsubforms.

--
--Roger Carlson
MS Access MVP
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

 

[John W. Vinson]

I am trying to reference a field that is part of a subform from the main
form.

For example, I want to change the background color of a field on a subform
based on a command on the main form. So I want to do something like this:

MainForm!Subform_name.field_name.backcolor - 255

But I can't get the syntax right.

Note that the subform name that you need is the Name property *of the Subform
control*, the box containing the subform. This will often be the same as the
name of the Form object contained within that control - but not necessarily.

The correct syntax would be

MainForm!Subform_name.Form!control_name.backcolor - 255

Bear in mind that forms don't have fields, they have controls; again, the name
of a textbox may be the same or different than the name of that control's
Control Source field.

John W. Vinson [MVP]

 

[Joe]

Thanks all, I really appreciate the help!