how to get the a name if i give the id.

[NAVIN KUMAR G P]

i have id and name in one table.
i have id his transactions in another table.
when i type the id it should display the name of the id.
is it possible? how?

 

[golfinray]

Put a combo box on the form. Allow the combo wizard to do that for you and
set it up for ID. Then right click on the combo and go to properties. Go to
events, click on the afterupdate event and start the code builder. Type:
Me.filter = "[id] = """ & Me.combo# & """"
Me.filteron = true

The combo number will be listed, like combo10 or combo22

 

[BruceM]

Type it where? It can be done, I expect, but it is not clear just what you
hope to accomplish.