populate combo box based on other combo box value

[rmh3619]

Hello all,

I have created a form with two combo boxes, one is named "customers" the other "reported_by".

I have created a query named "list_callers_by_company" which is populated by the folowing code in the row source
SELECT "*" as z from [list_callers_by_company] union select [List_callers_by_company].[caller_name] FROM [List_callers_by_company];

the query also contains a field named "company"

I want the reported_by combo box values changed so that only values are displayed where the company field of my query equals the company combo box value on the form.

Any help is greatly appreciated!

 

[Remou]

Have a look at the FAQs. For example:
Combo Box - dependant on another Combo Box
faq702-4289

 

[rmh3619]

Thanks for pointing that out remou!