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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking two Subforms & showing name in place of ID? 1
Enter the name and get automatically the personal ID number 4
Auto fill field on form 1
form for data with many to many relationship 2
Name saving as ID 5
Listbox SQL problem 2
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Linking form to sub form in Office 2007 2

Back
Top