I am trying to filter a form that displays data from an employees table. Each employee record has a scheduled departure date: [EndDate]. I want a user to be able enter the number of days into the future that they want to see upcoming departures: textBoxDays. For example, if the user wants to see a list of employees that will depart in the next month, they would enter 30. If they want to see the departure list for the next six months, they enter 180. In a query that works for a set period, the criteria for the field EndDate is < Date()+30. I want to be able to have EndDate < Date() + textBoxDays.
I have tried many combinations in the after update event but none seem to work. Thanks in advance.
I have tried many combinations in the after update event but none seem to work. Thanks in advance.