Form Help - ComboBox

[Bryan Brassell]

Please help!! I'm a form rookie!

I have a DataTable with the following data:
Key
A
B
C

For A, B & C, there is another table with descriptions of
each A, B, etc. They are related in descending heirarchy.

For each Key in DataTable, there is an A. The A
determines what choices there are for B, and so on for C.

I want the user to open the form, see all the entries in
DataTable, and then pick from a combobox what A should
be. I have this much figured out - I populated the
combobox from Table A. What I need next, is the B
combobox to be populated based on the entry in A. The
same goes for C. They are related as such:

Data Table
Key; A; B; C;

Table A
Category(key); Description

Table B
Category(the 'many' to the key in A); Subcategory
(key) ;SubCatDescription

etc.

Thanks,

Bryan Brassell

 

[Sandra Daigle]

The following KB article describes the method commonly used to synchronize
two combo boxes. Essentially, you simply use a reference to the first combo
box in the criteria for the rowsource of the second combo box. You would
just extend this to the third combo. Here's the KB article:

ACC: How to Synchronize Two Combo Boxes on a Form (Q97624)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q97624&SD=MSKB&