Help with syntax for where clause

[vulcaned]

Hi All,
Need help with the right statement for the following situation.
In Access97 I have a Form(frmComplaintUpdate) which has a Tab
Control(called TabCtl987) with several tabs(first tab we'll call
tbComplInfo). tbComplInfo has a subform(sbfrmComplaintInfo), on it,
that subform has two dropdowns(names-cboStatus, cboStatDesc).
The values displayed in the second dropdown are dependant on the value
chosen in the first dropdown. So, in the rowsource of the second
dropdown(looking at it in query grid mode)is

SELECT DISTINCTROW tblComplaintStatusTypes.StatusDescription FROM
tblComplaintStatusTypes WHERE
(((tblComplaintStatusTypes.ComplaintStatus)=[Forms]![frmComplaintUpdate]![sbfrmComplaintInfo].[Form]![cboStatus]));

What's Not working is the right side of the where clause -
[Forms]![frmComplaintUpdate]![sbfrmComplaintInfo].[Form]![cboStatus]

I know it's the syntax of it and that's what I'm stuck on, how do
I express

Display Status Descriptions Where ComplaintStatus equals the value
selected in cboStatus which sits on a subform which sits on a tab which
is in a tabcontrol which sits on a form

Thanks in advance for any assistance with this
bobh.

[Alan Webb]

Bobh,
My head hurts. I like things simple because I am an English major and all
this long, intricate reference to a deeply embedded object stuff starts to
make me feel small in the shadow of all these brighter math students I share
this group with . . . Ok, enough with the verbal fart. I tend to unbind the
combo box in a case like this and have it change the value of a module level
or application level variable or property. That way the source object can
refer to a simple variable name when it is setting the value and the
destination object can similarly refer to a simple variable name. With
Properties I gain the ability to make some choices about what value to
return when either no value is given by the source object or an
unnacceptable value is supplied by the source object. I hope this helps.
--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS"

<vu******@isp.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi All,
Need help with the right statement for the following situation.
In Access97 I have a Form(frmComplaintUpdate) which has a Tab
Control(called TabCtl987) with several tabs(first tab we'll call
tbComplInfo). tbComplInfo has a subform(sbfrmComplaintInfo), on it,
that subform has two dropdowns(names-cboStatus, cboStatDesc).
The values displayed in the second dropdown are dependant on the value
chosen in the first dropdown. So, in the rowsource of the second
dropdown(looking at it in query grid mode)is

SELECT DISTINCTROW tblComplaintStatusTypes.StatusDescription FROM
tblComplaintStatusTypes WHERE
(((tblComplaintStatusTypes.ComplaintStatus)=[Forms]![frmComplaintUpdate]![sbfrmComplaintInfo].[Form]![cboStatus]));

What's Not working is the right side of the where clause -
[Forms]![frmComplaintUpdate]![sbfrmComplaintInfo].[Form]![cboStatus]

I know it's the syntax of it and that's what I'm stuck on, how do
I express

Display Status Descriptions Where ComplaintStatus equals the value
selected in cboStatus which sits on a subform which sits on a tab which
is in a tabcontrol which sits on a form

Thanks in advance for any assistance with this
bobh.