Filtering Table Records on a form for data entry

[M McAllister]

I have a table (tblEmployees) with the following fields:
Location (Data already entered)
Employee (Data already entered)
Height (Need to update)
Weight (Need to update)
Haircolor (Need to update)

How do I create a form that will let me select the location in a combobox and then show me only the employees at that location. I then want to be able to enter the Ht, Wt & HairColor for each employee in that location.

I've looked up ComboBoxes and Split Forms, but I can't seem to put everything together. What am I missing?

Thanks in advance for any help.

 

[AngelJ]

Are you aware of Access' built-in filtering capabilities? Apply a filter to view select records in an Access database - Access - Office.com

Is there some reason you want to do this with a ComboBox instead?

 

[M McAllister]

AngelJ,

I'm not as familiar with Access as I am Excel and, somehow, got locked on the combobox train of thought. The filter worked perfectly.

Thank you. That's exactly what I needed.

 

[AngelJ]

Awesome! Glad I could help.