Hello I need some help with a combobox. This may fall under forms/queries and vba.
One of my forms (called cancellations) contains a field company_account number. When the company account number is entered the company_name will automatically appear on a field called....company_name.
I also have 5 product tables (lets call the tables product_a, product_b, product_c, product_d, product_e). Each product table will contain the company_account number only if the company is subscribing to the product.
On my cancellations form I would like to list the names of the products that the company currently subscribes to in a combobox once the company _account number is entered by the user. How can I get the combobox to query the 5 tables and output some text (e.g Book (if company exists in product_a table), CD (if company exists in product_b table), Web (of company exists in product_C table) etc.
One of my forms (called cancellations) contains a field company_account number. When the company account number is entered the company_name will automatically appear on a field called....company_name.
I also have 5 product tables (lets call the tables product_a, product_b, product_c, product_d, product_e). Each product table will contain the company_account number only if the company is subscribing to the product.
On my cancellations form I would like to list the names of the products that the company currently subscribes to in a combobox once the company _account number is entered by the user. How can I get the combobox to query the 5 tables and output some text (e.g Book (if company exists in product_a table), CD (if company exists in product_b table), Web (of company exists in product_C table) etc.
anyone able to help
