pull up data from a table into a form

[MattD00]

I have created a table with an ID field and a names field and added a few records. I then created a form and made a combo box using the lockup wizard to list all of the names in the table on the drop down. I then placed the ID field on to the form. I want it to work so that when a name is selected from the drop down there ID for that user is then displayed in the ID field on the form. How can I get this to work because when I get it working I want it to do the same thing for more information stored about the user.

[jgelpi16]

I think DLookup() would work perfectly for this.

http://www.techonthenet.com/access/f...in/dlookup.php

set the results of your DLookup() to the text box that you want to use to display your ID.