Hi,
I have setup a database that contains all of my employees information and work history.
I have two Tables, the first containing the employee info (name address etc..) and the second table the work history.
I have a form that loads the info from the the employee info table with a sub form containing the work history.
What I want to do is had a combo box on the form to select a year with a link that would open a report containing the work history for the selected employee for the year I have chosen from. I know how to do one filter, being for the current employee but not sure how to do the second filter being from the drop down for the year you have selected.
Any help would be appreciated.
Thank you