How do I populate a combo box

[Liz]

I have 2 combo boxes, the first contains a list of
information eg Home, Business, School etc

The second box contains lots of information which is
related to all of the above subjects. Eg Computer,
Television, DVD all for home use, Laptop, Mobile for
business use and jotters, pens, pencil all for school
use. How do I limit this box to only contain information
which is relevant to the item selected in the first combo
box. eg if I select home in the first combo box I only
want to see Computer, television. dvd in the second combo
box.

Thanks

 

[Sandra Daigle]

This is really just a matter of synchronizing combo boxes by making the
rowsource of the second combo dependant on the value of the first combo.
Here's a KB article that describes how to synchronize two combos - post back
if you need more help or further explanation.

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624