2 Column Drop Down Box

I am trying to create a field in my database that uses the lookup wizard and displays 2 columns. No problem so far, but instead of one column being the keyed field and the other being the description, I want to display the field that was selected by the user, regardless what column it's in. Is this possible?

Ex ColumnA ColumnB
John Barry
Steve Smith
Will Cherie

If the user selects Barry, Barry will be saved in that record. If the user selects Steve, Steve will be saved in that record.

Help,
Chris

A drop down box allows you to arrow down and select a row, not a particular
"cell". There would be no way for the user to select the left or right
portion.

You could create some type of union query to pull all the first names and
all the last name4s to one query, then use that as your source, but I fear
there would be other flaws in this design.

Rick B

"Chris" wrote in message
...
I am trying to create a field in my database that uses the lookup wizard and
displays 2 columns. No problem so far, but instead of one column being the
keyed field and the other being the description, I want to display the
field that was selected by the user, regardless what column it's in. Is
this possible?

Ex ColumnA ColumnB
John Barry
Steve Smith
Will Cherie

If the user selects Barry, Barry will be saved in that record. If the user
selects Steve, Steve will be saved in that record.

Help,
Chris