Access 2007 - Populate data from a Combo Box to Another Combo Box when adding a record

[lmcate]

I have a form that contains a combo with Managers Name called QA_ID, then another combo box . I want to take the value of the managers name and populate to another combo box that allows multiple select if more than 1 manager was involved for an employee review.

I can use the Me.QA__ID.Column(1) on CHANGE. and the value show. then I want to populate the field content to another Combo Box that with multiple entries.

 

[dhookom]

I don't understand your request.
What is your table structure?
Do you have a multi-value field that allows you to select multiple values in a combo box?
Do you have multiple reviewer fields in a table?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[lmcate]

Thank you for your reply
What is your table structure?
emp_id
Date_entered
firsntname
lastname
address
city
state
zipcode
qa_id (Manager combo box single entry
comments
manager_id (Managers Combo box with multiple selection)


Do you have a multi-value field that allows you to select multiple values in a combo box?
I have 1 combo box to select multiple Managers on the form. When I create a new record I want to populate the name from the combo QA_ID to Manager_id.

Do you have multiple reviewer fields in a table?
Yes, after toe record gets created it will save the manager name who added the record to managers_id. Also, Then couple days later another manager reviews form and then a check on managers_id adds a second name from the combo box.

Thanks,

Sam

 

[dhookom]

I would never use a multi-value field. I would create a related table that stores one record per manager review. The related table could have its own date and comments.

Why do you have FirstName, LastName, and other employee columns in your review table? Don't you have an employee table with these values? You typically would not store most of this information in multiple tables.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016