Hi everybody,
I have a combo box based on a query. Query itself has 8 columns based on 4 different tables. I am using the Bound Column 8 from my combo box as a value sent to another function.
I am trying to enable user to select one of the list and then based on the selection all related fields in different tables appear in a single text box, concatenated.
I have following tables:
tbl_customer: (customer_ID, first name, last name, phone, email)
tbl_makes: (make_ID, makes)
tbl_models: (model_ID, model)
tbl_molors: (color_ID, colors)
User selects a customer from combo box list once he/she sees the first Name, last Name, car make and model as well as car color. A customer can have multiple cars.
My relationship design is so that my query brings all the ID's in along with other info to display (ID's are not displayed obviously) in the combo box.
At the same time I need to have the ID of the selection passed to another function. I need that value.
I can not make the function to show all the info working.
What would be the best option to keep it simple and efficient.
I am flexible with your suggestions. I am a beginner and have not too much experience in Access or VBA. But I love working with VBA.
Thank you for your helps.
I have a combo box based on a query. Query itself has 8 columns based on 4 different tables. I am using the Bound Column 8 from my combo box as a value sent to another function.
I am trying to enable user to select one of the list and then based on the selection all related fields in different tables appear in a single text box, concatenated.
I have following tables:
tbl_customer: (customer_ID, first name, last name, phone, email)
tbl_makes: (make_ID, makes)
tbl_models: (model_ID, model)
tbl_molors: (color_ID, colors)
User selects a customer from combo box list once he/she sees the first Name, last Name, car make and model as well as car color. A customer can have multiple cars.
My relationship design is so that my query brings all the ID's in along with other info to display (ID's are not displayed obviously) in the combo box.
At the same time I need to have the ID of the selection passed to another function. I need that value.
I can not make the function to show all the info working.
What would be the best option to keep it simple and efficient.
I am flexible with your suggestions. I am a beginner and have not too much experience in Access or VBA. But I love working with VBA.
Thank you for your helps.