Combo Box to populate feilds in form

[vanlanjl]

I have added a combo box to my form (frmContact. I am trying to make it so you can search for a specific user in the combo box and then have it populate the appropriate fields in the form.

The code I have thus far (in Row Source):
SELECT [tblContacts].[Last Name], [tblContacts].[First Name] FROM tblContacts ORDER BY [tblContacts].[Last Name];

I would like it be where you can type in who you are looking for and either it find it for you or tell not found, but if it does find you select it and it will fill in the text boxes:

txtID txtCompany txtLastName txtFirstName
txtEmailAddress txtJobTitle TxtAddress
and so on..


So the combo box will find the user but it does nothing. Am i supposed to be using a WHERE command or maybe a IF command? Thanks for your help!

 

[TheAceMan1]

How are ya vanlanjl . . .

In access help [blue]answer wizard tab[/blue], perform a search for [blue]AutoLookup[/blue]. See [blue]Create an autolookup query that automatically fills in data[/blue].

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]