asked on

List box based on combo choice

I have a form with a combo box for listing all the assets we have. Since we now have over 10 different networks and thousands of different assets I want to do something different.

I want the user to be able to choose the network from the combo box and the list box display all the assets.

I have never user list boxes before so I have no idea how they work.

So this what I have:
Combo box is cbo_net; List box is HWB_List
cbo_net is based on the query, qry_Inventory

Thanks,
John

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Sheehy

ASKER

I am going to try this right now.

John Sheehy

ASKER

Won't let me type in the SQL syntax into the row source nor will it allow me to define it when the from loads, gives me a compile error: Expected: expression

This is how I have it entered:
Me.HWB_LIST.RowSource = Select qry_Inventory.Asset_Name FROM qry_Inventory WHERE qry_Inventory.Net = forms![Inventory Title Page].cbo_Net

John Sheehy

ASKER

Ok, so I see what I did. I did not set up the list box correctly. I am doing that now and will update in a minute.

John

SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Sheehy

ASKER

This is awesome. Worked like a charm and way more efficient than I expected. Thanks.