Split Form - Auto Populate

[CCAccess2010]

Hello,

I am having an issue creating a database and wanted to see if anyone could help. I have a contact list with names, addresses and phone numbers and I would like to create a search splitform so that when I type in a name it auto populates into the form and datasheet.

For Example

Combo Box - County - Saginaw
Text Box - Johnson
Form - 1st Johnson in list
Datasheet - all Johnson living in Saginaw County

I hope that this makes sense, I have been racking my brain and I cannot figure out how to make the form populate.

Please, help!

[ajetrumpet]

that's actually quite simple. you can put the combo on the top half of the form, then subform on the bottom half, set the default view to datasheet, and bind it to a query that is written such as:

SELECT * FROM TABLE WHERE

[county] = forms!mainform!combo

on the afterUPDATE event of the combo, simply write:

me.subform.form.requery

[CCAccess2010]

I'm not allowed to view the form in datasheet view, I actually wanted to type in the information into a search box so that when they put in any source of information it will autopopulate in the form and subdatasheet below. For example, if they put in the county it will bring up all information associated with that county. However, if they put in a person's last name into the same text box it will bring every person with that last name. Does that make sense?