Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

lmcate

MIS
Jan 17, 2012
36
US
I have a form and I want to copy the employee id 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
 
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
 
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
 
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
 
This is correct KJv1611 I meaant a combo box with 3 fields and have the ID store but search by the name.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top