Lookup control issue

#1

I have a look-up field that is linked to a table of only 2 fields. The 2
fields are ID# and Name. When I choose from the list in the table or the
form I can only see the ID# in the field after the choice is made. I want to
see the name. Help!!!!

#2

set the columns length of the look-up field to 0. This will hide the ID and
show the name. Obviously the query of the look-up field must contain the ID
and the name fields (in this order).

"Barbara Warszycki" <bjw3kids (AT) aol (DOT) com> ha scritto nel messaggio
news:WjHwe.4163$SQ1.3103 (AT) fe09 (DOT) lga...

Quote:

I have a look-up field that is linked to a table of only 2 fields. The 2
fields are ID# and Name. When I choose from the list in the table or the
form I can only see the ID# in the field after the choice is made. I want
to
see the name. Help!!!!

http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Lookup control issue

comp.database.ms-access comp.database.ms-access

Lookup control issue - 06-29-2005 , 07:47 PM

Re: Lookup control issue - 06-30-2005 , 10:28 AM