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 strongm 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
- Thread starter lmcate
- Start date
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
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
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
- Thread starter
- #4
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
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
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
- Thread starter
- #6
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
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
- Status
Similar threads
- Locked
- Question
- Locked
- Question
