Displaying label instead of number from lookup field

[Guest]

I created a form based on a query. Some of the fields in the underlying
tables have lookup boxes associated with them, for instance:

1-pos
2-neg
3-not compl

Data entry is done by numbers (b/c it's faster), however, I would like to
display the associated label (pos/neg/not compl) in the control on the form,
b/c it is easier to understand for the people doing the data entry.

Is there any way to do that?

 

[Albert D.Kallal]

Use the wizard to build a comb box on the form as follows.....

If the 1st column is the primary key, then the wizard will set the length to
0..and you will NOT see the number...

open up the combo box in design mode..and set the length of the 1st column
to non zero..

(in the wizard you can often un-check the "hide" key column...and you thus
should get a non zero length for the 1st col).

When you build the combo box, make sure you display the 2 columns you want
(1 col = your number, 2 col = description).


when you get the above working, then just place a text box on your screen,
and set the source of the text box to the 2nd col above..

It would look something like:
=([combo31].[column](1))

note that we use (1) in the above for the 2nd col, since it starts at 0 for
the first column...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.members.shaw.ca/AlbertKallal


Have the co