Access 2010: How to Have a Form Only Generate Data for One Record
Posted on 2016-08-30
Someone built a Microsoft Access 2010 .accdb file for us. Unfortunately, the form that we use to generate reports per salesperson from this file contains a filter but only by document date.
I need to have this form--just this one time--generate reports for only one salesperson, in particular. I'm not Access savvy, at all!
Anyway, I do see an object of some sort on the left-hand side of the window called "salespeople". When I open it, I can filter it by the one salesperson. But, how do I know that the form is going to generate a report for only that one salesperson? In other words, how do I apply this filter to that form?
This is not going to be permanent. Again, I want to apply this filter, just this one time.