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