I have a form with 2 combo boxes to select records on a main form showing the company, then I have 2 subforms - one showing the Offices and the other showing the contacts.
I created a command button to filter and show the current selections. My problem is: the focus stays on the 2nd combo box and I would like it to move to the Company Name. Then if they click the Filter button I would like it to filter by the Company name - without having to click on the filter by selection button - it then opens a Report that they can print the info from that 1 company. Now when I close the report I would like the filter to be turned off instead of having to click on the Remove Filter button.
Thanks in advance.