I am very new to MS access and I am trying to create a database where people would fill out forms such as a startup checklist, machine inspections and so on. I also would like the database to automatically create reports on this criteria. I have the forms setup and working properly along with the reports.
The problem is I added a button to sort the report by Date and it is working properly until I try to select a new date it always reverts back to the first date I sorted.
The macro I have embedded in the button is as follows:
SetTempVAR
Name tempDate
Expression: InputBox("Please Select a Date")
SetFilter
Filter Name: BLANK
Where Condition =[InspectionDate]=[TempVars]![tempDate]
Control Name: BLANK