?
Solved

Display the second field in a combo box after a selection is made

Posted on 2013-02-06
1
Medium Priority
?
353 Views
Last Modified: 2013-02-06
I have a table that has CustomerNumber as the first field and CustomerName as the second field.

The invoice form has a combo box where the user can enter the customer number. We want the customer number to be displayed in this field. But when the user clicks the drop-down arrow for the combo box, we want the user to be able to type a customer name and have it jump to that customer name as they type. Once they have made a selection, we want the customer number to be displayed in the combo box.

Is there a way to do this? If I make the first visible column in the combo box the customer name, the drop-down typing works fine but the customer name is displayed in the field once a selection is made. If I make the first visible column the customer number, the typing in the drop-down goes by customer number instead of name.

Thanks in advance.
0
Comment
Question by:jrmcanada2
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 900 total points
ID: 38861731
No can do...

A combobox can only display the value from one Field.

You can, however, display any column from the combobox in a textbox on the form.

Code roughly like this on the afterupdate event of the combobox:

Me.txtCustID=me.YouCombo.Column(0)
(this presumes that the first column in the combobox is the CustID)
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question