Use of Lookup Column Versus Listbox

[P5C768]

I know this is a common problem, but I couldn't find an answer using the search.

I have a list of companies and a seperate list of the products each company offers. My goals is to have a form that allows a dropdown listbox where the user can select a company and once the company is selected, a second listbox is populated with the 3 to 5 products the company offers.



What is the most effcient way to do this? Lookup columns on the table where the data is stored? Or is there a way to do it just using list boxes on a form?

Thanks!

[pbaldy]

List boxes would work the same as combos:

http://www.baldyweb.com/CascadingCombo.htm

[carlmdobbs]

I know this is a common problem, but I couldn't find an answer using the search.

I have a list of companies and a seperate list of the products each company offers. My goals is to have a form that allows a dropdown listbox where the user can select a company and once the company is selected, a second listbox is populated with the 3 to 5 products the company offers.

What is the most effcient way to do this? Lookup columns on the table where the data is stored? Or is there a way to do it just using list boxes on a form?

Thanks!

Hello. It is simple for those who know VBA and SQL. You need to
actually use the "after update" event of your company combo box to give a second list box or combo box a new rowsource. This will enable them to pick a product. If the list box is multi-select you can enable them to pick several products from it.

MS Access's combo boxes also have the ability to display a check mark along side the list. This can enable the user to select more than one item from the combo box. I do not recommend this, though, as it has drawbacks from a programmer's point of view.

I can teach you how to solve your problem. I donate hours to people who use this blog and wouldn't mind allotting you 2 hours for this. If you are interested I can write the VBA code for you.

Carl Dobbs
Dobbs Comptuter Institute