Populating a combo box in Access 2000

[Alexander]

I'm fairly lousy at coding and I really don't know how to do this. I have 3 ComboBoxes. The information in ComboBox #1 one will determine what will be shown in ComboBox #2, which will then show what may be selected in ComboBox #3. Given the circumstances, this is the data and the fields I need to use: ComboBox #1 is called Firm_Type_Code. There are approximately 12 codes in the list. Depending on the code #, it will then populate ComboBox #2, called Enforcement_Type_Code. About 12 more codes are in this list. Depending upon this code #, ComboBox #3, called Letters, will supply the necessary information. At least 50 letters will be in this list.

Example:

If Firm_Type_Code = either 03 or 04, Then
Enforcement_Type_Code = 00 Then
Letter = 01, 02, 03, 04, or 05

I need to know how to write this correctly in VBA. Thanks for whatever help you can lend.

 

[Alexander]

Please help me. I'm running out of time to get this done and I really don't know what to do. I'm not good at coding, which is why I'm posting this. Any suggestions whatsoever would be appreciated.

Zoegirl