E
Ed
I am using the technique to find a record based on a combobox drop down (see
http://allenbrowne.com/ser-03.html if interested in technique). My solution
has 2 combo boxes: the first is to select a company and the second selects an
employee within the company.
When you change companies, the form loads all the employees for the company
and then I can use the second combobox to find a particular employee and
display them.
I found an issue that occurs if I filter the form and then I change the
company in the drop down. The recordset will not load the employess for the
new company I selected (but the employee combobox does load the correct new
employees). I have to close the form and re-open it to be able to change
companies after I use filtering. I tried putting in code to turn off the
filter and also set it to "" but that did not solve this problem.
http://allenbrowne.com/ser-03.html if interested in technique). My solution
has 2 combo boxes: the first is to select a company and the second selects an
employee within the company.
When you change companies, the form loads all the employees for the company
and then I can use the second combobox to find a particular employee and
display them.
I found an issue that occurs if I filter the form and then I change the
company in the drop down. The recordset will not load the employess for the
new company I selected (but the employee combobox does load the correct new
employees). I have to close the form and re-open it to be able to change
companies after I use filtering. I tried putting in code to turn off the
filter and also set it to "" but that did not solve this problem.