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

When Create a new record copy a field record to a drop down field with many choices

When Create a new record copy a field record to a drop down field with many choices

When Create a new record copy a field record to a drop down field with many choices

(OP)
I have a form and I want to copy the employee id to a drop down field with many choices

RE: When Create a new record copy a field record to a drop down field with many choices

"Copy" suggests you have a source and a target. What are your Source and Target?

Can you provide some context regarding what you are attempting to accomplish?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: When Create a new record copy a field record to a drop down field with many choices

Do you really mean you want to "select" the associated record in a drop-down (combo-box) when you enter the employee ID in a text box? But yes, you definitely need to provide more information to get a good answer.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

RE: When Create a new record copy a field record to a drop down field with many choices

(OP)
I have a drop down list ID, Firstname, Lastname. When the drop list show I want to search by firstname and when I press enter then it grabs the ID and saves this to the field.

like.

1111 Ana Jones
2222 Joe Pitzer
3333 Richard Mates

on the drop down I want to type joe and the field store 2222.

Thanks,

Sam

RE: When Create a new record copy a field record to a drop down field with many choices

So is it not doing this now?

A drop down list is a ComboBox in Access forms by definition. Make sure you're using the correct terminology also to get the best response. You could theoretically be speaking of a list box or maybe something else.

When you build a combo box, you can tell it what to show and what to store and where to store it. It stores one value even if it shows multiple. So if the ID is the first field in the query building the list, then it's storing that. If the name is the first field, it's storing that unless you specify otherwise.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

RE: When Create a new record copy a field record to a drop down field with many choices

(OP)
This is correct KJv1611 I meaant a combo box with 3 fields and have the ID store but search by the name.

RE: When Create a new record copy a field record to a drop down field with many choices

If you want to search by name then hide the first column so the name column is the first visible column.

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