Autopopulate???

[pablotx]

Got a problem I can't figure out. I will try and explain in my newbie language.

I have a list of companies and a very long list of employees who work in those companies. On my form, would want the user to be able to select a company from a combo box. Afterwards, I would want another combo box be populated with only the employees from the selected company so that they could select the employee without scrolling down for an hour....
How can I make this happen?

 

[Banana]

That'd be a cascading comboboxes. Assuming your db is normalized, you can read it here

 

[RuralGuy]

Search this forum on "Cascading combo".