By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,756 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Combo Box for lookup. Want to store KEY value but not display

P: n/a
I have a form with a combo box on it. The combo box's source is a
access lookup table with two columns, EmployeeName & EmployeeNumber.
I want to display the EmployeeName from the dropdown but store the
EmployeeNumber. I was able to get this work (for the most part) by
setting the Bound Column to 2 and setting the column widths property
to 0.5";1"

The problem is after I click the drop down to select the record that I
want the EmployeeNumber is displayed in the box on the form. How can
I get the EmployeeName to display there instead?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Assuming column 1 is the id_number and 2 the name, bind the data to the id,
set column count to two, and coluumn widths to 0;1.5". Make sure the
combobox width is set to 1.5".

If the id number has been set up correctly - where the actual value of it is
meaningless - then there should be no need to display the id number at all.

Most often, I use a query as the rowsource rather than just the table name,
to make it clear where the columns are, and to order the rows.
Darryl Kerkeslager

"Rich" <td*******@yahoo.com> wrote in message
news:22*************************@posting.google.co m...
I have a form with a combo box on it. The combo box's source is a
access lookup table with two columns, EmployeeName & EmployeeNumber.
I want to display the EmployeeName from the dropdown but store the
EmployeeNumber. I was able to get this work (for the most part) by
setting the Bound Column to 2 and setting the column widths property
to 0.5";1"

The problem is after I click the drop down to select the record that I
want the EmployeeNumber is displayed in the box on the form. How can
I get the EmployeeName to display there instead?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.