Automatic Update in Subform

[zyousafi]

I have a form which is basically used as an Evaluation Form of a Contact Center Agent. The form and the calculations work absolutely fine; however I want to add something that will make this form great. What I had in mind was having a subform within this form that would ultimately display the results for all of the agent's evaluations in the past month. The person doing the evaluation would select the agent's name in the top part of the form and the date would automatically fill in with today's date; however can the results display only the relevant month's data instead of the entire dataset?

 

[Kryst51]

Yes it can, you would filter the query that populate's the subform with the current month... There is a function you can use. See my link for details.

 

[zyousafi]

Okay great, that works like a charm! Thank you.

 

[Kryst51]

Youre Welcome, glad I could help.