Combo Box that items in list expand???? 1

[fmg010]

I have a data entry form that has 3 fields that require customer complaint codes. I have a table that lists all of the complaint codes. I would like to use a combo box that will list all of the different categories in the complaint code table and when one of the categories is selected then another list appears with all of the items within that category. I have all of the complaint codes in one big table as described above, I also have seperate tables for each category.

Anyone have any suggestions?? Mike Garcia
Associate Manager
PCS Sector
Motorola
FMG010@email.mot.com

 

[JoeMiller]

Check out this FAQ by RickSpr

faq702-681

Joe Miller
joe.miller@flotech.net

 

[fmg010]

That helped, thanks Joe. Mike Garcia
Associate Manager
PCS Sector
Motorola
FMG010@email.mot.com