Question Cascading Combo Box

[cms2012]

This is my first time on the forums, so bear with me. I have a form that has two combo boxes. One is called cmbDate and the other is cmbsalesperson. When I choose the date in cmbDate it filters the names in cmbsalesperson. Now, when I choose a name in cmbsalesperson it autopopulates four text boxes.

I have another group of text boxes that needs to be filled with the previous years data. I was wondering if there was any way to choose the previous years data for the person I select in the cmbsalesperson

 

[cms2012]

Sorry I'm confused on what you mean.

I put the criteria in the cmbsalesperson query for the control to say that when the Date field in the cmbsalesperson = cmbDate it puts the names of the people who sold in that month in cmbsalesperson. How would I change the filter in this case?

Sorry if this is confusing, I know a little access but I'm still a novice.