ComboBox populates from seperate Form ComboBox

[scoobz1234]

Hello,

I am trying to set up two Forms the first one you select from a ComboBox a Company, then you press the Continue button and it opens up the Second Form, on this form you can input Employee details, within this form i have a Search function, the search function is a ComboBox that gets its information from the main database which is HUGE over 1000 names, because the main database has all the different companies employees in it, is there a way when i select a company in the first form i want it to filter the second forms combo box to show only employees from that company.

i was able to do this within the same form... all i had to do is set the top combo box to refresh after input, and the second combo box had a criteria set in row source to forms!frmInput!combo1.

that worked fine... however i wanted to simplify the process and add a second form (which will be the form that opens first) that the combo2 gets its information from...

im sorry if this is confusing it all made sense to me while i was typing...

[June7]

Have you considerd a form/subform arrangment? Review: http://office.microsoft.com/en-us/ac...101872705.aspx