Row Source data in sub-form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill946 - 02 May 2007 15:48 GMT

I have some Row Source Data that worked OK under Office 200 but now we have
transferred to Office 2003 doesn't.
The data is "SELECT data_stans_combined.Para, data_stans_combined.Title FROM
data_stans_combined WHERE
(((data_stans_combined.Stan)=Forms!MyAudits!frmPlanMyAudit!ExternalStandards.Value)) ORDER BY data_stans_combined.Para;"

On the "Forms!MyAudits!frmPlanMyAudit!ExternalStandards.Value" I have a Form
named MyAudits on which there is a subform frmPlanMyAudit, the trouble is
that the subform (frmPlanMyAudit) is on a tabbed page and I do not know how
to get the tab into my Row Source Data and I think that may be the problem.
I think I need something to replace the question marks to show the tab
"Forms!MyAudits!????????????!frmPlanMyAudit!ExternalStandards.Value". Can
anyone help please?

Reply to this Message

John W. Vinson - 02 May 2007 17:19 GMT

>I have some Row Source Data that worked OK under Office 200 but now we have
>transferred to Office 2003 doesn't.
[quoted text clipped - 9 lines]
>"Forms!MyAudits!????????????!frmPlanMyAudit!ExternalStandards.Value". Can
>anyone help please?

The Tab Control is *completely irrelevant* to the naming convention. A Tab
Control is simply a way to arrange screen real estate - it has no effect
otherwise.

If you have a subform control (whether it's on a tab page or not) the syntax
is

Forms!MainFormName!Subformcontrolname.Form!controlname

where Subformcontrolname is the Name property *of the Subform control on the
main form* - this might or might not be the same as the name of the Form
object within that box.

The .Value property is the default; I don't think it hurts to include it but
it is not needed.

John W. Vinson [MVP]

Reply to this Message