INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

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

(OP)
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.

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

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

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

(OP)

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

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close