enter number in combo box, but have associated name appear on form

  • Thread starter Thread starter Katt
  • Start date Start date
K

Katt

I have a form with mostly numeric data, but with one combo box that
holds a site name. I would like to be able to type a numeric code in
the combo box, but have the associated site name appear in on the form
(in the combo box or in another box). I need to be able to see the name
to verify the data entry (my memory not being what it used to be). Is
it possible to do this? Any assistance would be greatly appreciated.

Thanks,
-Katt
 
Do you have a lookup table that is the row source of your combo box? You can
set the various properties of the combo box to display the bound column or
any other column in the Row Source. To hide the first column and display the
second, set the column widths property to something like:
Column Widths: 0";1"
 
Thanks for your reply. Yes, the row source is a lookup table with the
numeric code and the site name. I tried setting the column width for
the numeric code to zero. It then shows the only name in the drop-down
list, but it won't let me type the number to select the correct row.
I'm trying to type the number on the 10-key (without using the mouse or
the keyboard, proper), but have the name appear.

-Katt
 
You can set the row source to something like:

SELECT SiteID, SiteID & " - " & [SiteName]
FROM tblSites
ORDER BY SiteID;
 
Back
Top