If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access a subform in a query
What is the sysntax to refer to a subform in the conditions statement of a
query I tried the following [forms]![orders]![subform].[orderdetail]![pricetable] but that doesn't work thanks |
#2
|
|||
|
|||
Access a subform in a query
There's a great explanation of Form/Subform Referencing on
www.mvps.org/access HTH -- -Larry- -- "Nigel" wrote in message ... What is the sysntax to refer to a subform in the conditions statement of a query I tried the following [forms]![orders]![subform].[orderdetail]![pricetable] but that doesn't work thanks |
#3
|
|||
|
|||
Access a subform in a query
I'm not sure that you can reference a subform's controls in a query. As I
recall the expression service won't handle this. I believe that what I have done in the past (long ago and far away) was to add a control to the main form (visible = no) and either set the value of the main form control from the subform or reference the sub-form control as the source of the main form control. All of this is based on my notably faulty memory. John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County Nigel wrote: What is the sysntax to refer to a subform in the conditions statement of a query I tried the following [forms]![orders]![subform].[orderdetail]![pricetable] but that doesn't work thanks |
Thread Tools | |
Display Modes | |
|
|