Drop Down Lists in an Access Data Project

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
dependent, multiple variable, drop down list 2
Filtered Drop Down Menu Based on Previous Drop Down Selection 1
Drop Down List Question 5
Formatting combo box drop-down list 2
Need to Cascade Multiple Drop-down Lists 5

Top