Auto populating the form using first Name

[sai pavan]

Hey guys, I want to create a form where the form can be searched just by using first name of an employee. After selecting the employee it should auto populate the whole form. Can anyone help me with this ?

Thanks in advance.

 

[Ranman256]

put an unbound text box on the form, txtName
and a combo box with all the employees showing FIRST,LAST (id hidden)

the combobox query looks at the txtBox on the form to filter FIRST.
in the AFTERUPDATE event of the txtbox, requery the combo and the name(s) should be in the combo box.
The combo box is bound to FIRST on the form.

 sub txtName_afterupdate()
     cboBoxName.requery
 end sub

 

[sai pavan]

put an unbound text box on the form, txtName
and a combo box with all the employees showing FIRST,LAST (id hidden)

the combobox query looks at the txtBox on the form to filter FIRST.
in the AFTERUPDATE event of the txtbox, requery the combo and the name(s) should be in the combo box.
The combo box is bound to FIRST on the form.

 sub txtName_afterupdate()
     cboBoxName.requery
 end sub

I have tried the above method but I'm not able to solve it. I'm very new to access. Could you please help me in detail. I just want to create a combobox with first name in it and by selecting the employee the form should autofill all his details.

Thanks.

 

[Minty]

Have you had a look at the Sample Northwind Database that is included with Access? It has this functionality with some added bells on in the examples.