ID and Name box question

[sadbttru]

Hello,

please excuse me if this is a simple question. i have done this on other DB but i am rusty!

i want to enter an ID# and have the name associated with that ID automatically inserted in another box.

i have created both a name query and ID table. but for the life of me can not remember how to get this to work!

ex:

enter ID# ##### name: YYYYYYYYYYY

 

[Smart]

Create a query that selects the Id and name in the criteria section under name type
forms![yourform]![yourcomboboxname]

In the after after update of the Id field on your form
Type
Dim IDname as string

IDname = nz(dlookup("ID","Queryname"),"")

Yournamefieldon the form = IDname