P
Paul Scott
Hi,
I have a form with two drop down lists. The value chosen
in the first list, limits the value available in the
second list.
E.g.
List1 List2
Customer Complaint
Customer Query
Store Stock
Store Location
If Customer is chosen in drop down 1, the only value
avaiable in drop down list 2 would be Complaint or Query.
In an Access MDB I'd enter something like
SELECT Res_Code_2
FROM ListMenus
GROUP BY Res_Code_2, Res_code_1
HAVING (Res_code_1 = forms!frmMain!List1)
in the rowsource query.
But in and ADP, all you can enter is a ? in the criteria.
On a form there is Input Parameters where you specify what
fills the ?, but what do you do for a control?
Hope this makes sence to someone!
Thanks
Paul
I have a form with two drop down lists. The value chosen
in the first list, limits the value available in the
second list.
E.g.
List1 List2
Customer Complaint
Customer Query
Store Stock
Store Location
If Customer is chosen in drop down 1, the only value
avaiable in drop down list 2 would be Complaint or Query.
In an Access MDB I'd enter something like
SELECT Res_Code_2
FROM ListMenus
GROUP BY Res_Code_2, Res_code_1
HAVING (Res_code_1 = forms!frmMain!List1)
in the rowsource query.
But in and ADP, all you can enter is a ? in the criteria.
On a form there is Input Parameters where you specify what
fills the ?, but what do you do for a control?
Hope this makes sence to someone!
Thanks
Paul