Dynamic Subcategory List Box

[BD]

I would like to create a dynamic subcategory listbox that
displays only options appropriate to the initial main
category selection. For example, I have a main category
list box that contains Drinks, Snacks, etc. If I
select "Drinks" in the Main Category, I would like the
next field (sub-category) to display only Coke, Pepsi,
etc. Any help would be appreciated. Thanks.

 

[Ken Snell [MVP]]

See The ACCESS Web for a way to link combo boxes...listboxes will work
similarly.
http://www.mvps.org/access/forms/frm0028.htm.

 

[BD]

Thanks for the reply. Unfortunately, I am not a
programmer so I have not been able to make that work.

 

[Ken Snell [MVP]]

You don't need to be a programmer to make this work... at least, I don't
think so! ;-)

Where are you running into difficulty with it?