Dick7Access
Dick S
- Local time
- Today, 04:44
- Joined
- Jun 9, 2009
- Messages
- 4,197
My form source is a query that sorts by dates. (Between #1/1/2020# And #12/30/2020#)
However, when opening the form in datasheet view it ends records at July 3,2020. Checking the property sheet, I discovered the filter property had
Filter: ((((tlbMain.enterDate) Between #6/1/2020# And #7/3/2020#))
and the Ordered by property had
Ordered by: tlbMain.enterDate DESC
I have removed the filter property and ordered by, a few times, but they keep coming back.
I had this happen to me years ago but I do remember how to fix it. I usually put information like this in my “How To” db but it is not there.
Anybody got a clue?
However, when opening the form in datasheet view it ends records at July 3,2020. Checking the property sheet, I discovered the filter property had
Filter: ((((tlbMain.enterDate) Between #6/1/2020# And #7/3/2020#))
and the Ordered by property had
Ordered by: tlbMain.enterDate DESC
I have removed the filter property and ordered by, a few times, but they keep coming back.
I had this happen to me years ago but I do remember how to fix it. I usually put information like this in my “How To” db but it is not there.
Anybody got a clue?