Populate form from drop down field.

[Batch]

I have created a table with, among other things, peoples names, phone number and location. This table was populated with a form containing those fields. I have also inserted a dropdown field in the header that is linked to the names in the table. What I want to be able to do is click this field, have the names drop down, select a name and then have all the fields in the form populate with that individuals information.

I don't think it's too hard to do, but I'm fairly new to Access 2013 and I haven't been able to find the solution online.

Any help would be greatly appreciated.

[andy49]

Combobox should have

select personID, firstname,surname
From tblpeople
Order by surname.

In the on change event of the combobox type

Me.filter = "personID = " & cboname.value
Me.requery

That should do it.

Cboname your drop down box
PersonID the primary key in the table

[ssanfu]

I think the Me.FilterOn property needs to be set also:

Me.filter = "personID = " & cboname.value
Me.FilterOn = True
Me.requery

[andy49]

Thanks Steve. Basic error!!

[HiTechCoach]

TIP: The combo box wizard has a Find Record option. It is the third (bottom) option. It will create what you want.