ComboBox 1 to determine BocmboBox 2 items 1

[Dawnit]

Sorry, left subject off first thread!

Thanks in advance to as many of you who will be able to give me answers/options:

I have a form with two combo boxes, each has an SQL row source property that returns unique records from two different tables: descriptions and sub-descriptions.

In the first combo box, I have 15 descriptions to select from. In the second combo box I have 25 sub-descriptions.

If I select 1 of the 15 descriptions, how can I get the second combo box to return only the 8 sub-descriptions that actually relate to the 1 description that I selected in the first combo box?

Example: If I select "Audit Reports" from the first combo box, I want the second combo box to show only the 8 subdescriptions that apply to Audit Reports?

I sure could use some help. Thanks!!!!

 

[JoeMiller]

View RickSpr's FAQ on the subject:

How do I limit the contents of one combo box based on the selection in another?
faq702-681 Joe Miller
joe.miller@flotech.net