link a name with ID , so that when ID is entered name appears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to link a ID with name so that if i entered the ID name linked should
appear automatically.
 
Neeraj,
Whenever you select a key value on a form... consider a combo box.
Create a 2 column combo box populated with 1st col = ID, and 2nd col =
Name
Make the ColumnCount 2
Make the Widths 0";2" (first width must be 0)
Set the ControlSource of the combo to your ID field in the table behind
the form.

Now... users can select a name from the combo (the ID doesn't even
show).
That Name "displays" in the combo, but... what's really "stored" in that
combo field is the ID! (Which, is all you need to store to define a Name...
and hence, all the info associated with Name.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top