Hello,

I think this should be easy () but I cannot see away to do it.

In one of my data-entry panels I need to present the inputter with a series of options in text so that they can read it and decide what one to pick. However, I need a specific value to be entered in the database.

I envisaged something like the following

Text Value
Label 1 "200"
Label 2 "210"
Label 3 "220"
... "..."

The person entering data would see a drop down list containing the various labels in column one. S/He chooses on and the associated value in column 2 is passed to the database. The inputter would only see the labels from column 1 and the mechanics of the database would do the conversion from label to value and enter the value in the database.

Sounds like it should be doable (:D). If I use a web page to enter the data then the whole thing is very easy, but...

It sounds like your are looking for a combo box or list box

Depend on which version of access you have look up help information on
"About creating a list box, combo box, or drop-down list box that looks up values". create your drop down list on the form and try not use look on the table.

Jemacc,

Thanks for that. I am using Access 2000. I'll have a look again and see if i have missed anything.

John,

Create a combobox on your form. The rowsource could be a table that has two fields. One is the label, one is the value.

Open the combobox's property window and set its number of columns to 2. Set its BOUND column to Column 2 (the value). Set the column widths to, say, 1"; 0". This will hide the values and only show the labels.

Because the bound column is the second one, when the user chooses a label, Access will use the value (not the label) in its calculations.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Greg,

Got round to doing it your way. worked thanks

Head of innovation and Industry Services,
Faculty of Applied Arts