B
BonnieW via AccessMonster.com
Hi everyone!
I have an unbound form. On that form is a tab control, and on that tab
control is subform and another subform.
How it's laid out:
____________
FORM (unbound)
-tab
--subform (bound) (combo box 1)
---subsubform (bound) (combo box 2)
_____________
On my subsubform, I have a combo box which references a combo box in the
subform- in the subform you choose a route, in the subsubform you choose a
stop. When I open up my subform directly, everything works peachy-keen: the
combo box on the subsubform populates correctly. However, when I open FORM,
I get an "Enter parameter value: (name of combo box on subform that is being
referenced)."
The SQL behind my query:
SELECT tblAnuraPoints.AnC_Site_ID_KEY_NEW, tblAnuraPoints.AnR_Route_ID_NEW,
tblAnuraPoints.AnC_Point_Name, tblAnuraPoints.Active, tblAnuraPoints.Sequence
FROM tblAnuraPoints
WHERE (((tblAnuraPoints.AnR_Route_ID_NEW)=[Forms]![sfrmAnuraVisit]![cboRoute])
AND ((tblAnuraPoints.Active)=Yes))
ORDER BY tblAnuraPoints.AnC_Point_Name, tblAnuraPoints.Sequence;
So, why is it doing this, and how can I get it to just *work*? Thanks in
advance!
I have an unbound form. On that form is a tab control, and on that tab
control is subform and another subform.
How it's laid out:
____________
FORM (unbound)
-tab
--subform (bound) (combo box 1)
---subsubform (bound) (combo box 2)
_____________
On my subsubform, I have a combo box which references a combo box in the
subform- in the subform you choose a route, in the subsubform you choose a
stop. When I open up my subform directly, everything works peachy-keen: the
combo box on the subsubform populates correctly. However, when I open FORM,
I get an "Enter parameter value: (name of combo box on subform that is being
referenced)."
The SQL behind my query:
SELECT tblAnuraPoints.AnC_Site_ID_KEY_NEW, tblAnuraPoints.AnR_Route_ID_NEW,
tblAnuraPoints.AnC_Point_Name, tblAnuraPoints.Active, tblAnuraPoints.Sequence
FROM tblAnuraPoints
WHERE (((tblAnuraPoints.AnR_Route_ID_NEW)=[Forms]![sfrmAnuraVisit]![cboRoute])
AND ((tblAnuraPoints.Active)=Yes))
ORDER BY tblAnuraPoints.AnC_Point_Name, tblAnuraPoints.Sequence;
So, why is it doing this, and how can I get it to just *work*? Thanks in
advance!