lookup help

[awrex]

Your help is appreciated!

I'm trying to have a lookup display one value and show that value though I
want a another value actually entered, I hope this makes sense.

I have a form with a text value that displays a location (ex. Los Angeles,
Chicago), attached to each text value is a autonumber primary key (ex. 1,2).
I want the form to show the text value but store the primary key as the
value.

Currently all I can get to work is having both the columns show the values
on the drop down list (ex. 1 Los Angeles).

I'm looking for the easiest way to do this? I basically know how to start an
auto wizard and that's about it. I have a few books on VBA and Access, but no
matter how much I read them it makes about as much sense as ancient sanskrit
to me.

THANKS AGAIN!!

 

[Allen Browne]

If you already have the 2 columns in your combo, you can hide the first one
by setting the combo's Column Widths property to:
0

 

[awrex]

Works great!! THANKS!!!!!!!!!!!!

If you already have the 2 columns in your combo, you can hide the first one
by setting the combo's Column Widths property to:
0