Thanks in advance to as many of you 1

[Dawnit]

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!!!!

 

[LonnieJohnson]

The row source for the second combo box is going to need a WHERE clause that will select records that meet certian criteria. Not knowing your field names it's kinda hard to write the statement.

B-) ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV