accessing data on a subform...

[Brad Pears]

I can not find the sytax for accessing subform data. I thought it was like
this...

strText = forms![MainFormName]![SubFormName].[Field1] but this doens;t
seem to work....

Can some one help me?


Thanks,

Brad

 

[Wayne Morgan]

Replace SubFormName with:

NameOfSubformControl.Form

The NameOfSubformControl is the name of the control on the main form that
holds the subform. To get the name of this control, open the main form in
design mode, open the Properties sheet, click on the subform ONE time. The
Properties sheet should show the name of the subform control. If you click
on the subform a second time, you'll be in the subform and the Properties
sheet will show the name of the subform, not the control holding it.

 

[Brad Pears]

Still having problems with the syntax....

The subform control name is child-issues... So to access the field "field1"
on this subform how would I write the reference?

forms![frmMain]![child-issues.form].[Field1] ????

Thanks,

Brad

Replace SubFormName with:

NameOfSubformControl.Form

The NameOfSubformControl is the name of the control on the main form that
holds the subform. To get the name of this control, open the main form in
design mode, open the Properties sheet, click on the subform ONE time. The
Properties sheet should show the name of the subform control. If you click
on the subform a second time, you'll be in the subform and the Properties
sheet will show the name of the subform, not the control holding it.

--
Wayne Morgan
MS Access MVP

I can not find the sytax for accessing subform data. I thought it was like
this...

strText = forms![MainFormName]![SubFormName].[Field1] but this doens;t
seem to work....

Can some one help me?


Thanks,

Brad

 

[Van T. Dinh]

Should be:

Forms![frmMain]![child-issues].Form.[Control1]