Dumferling
Member
- Local time
- Today, 04:34
- Joined
- Apr 28, 2020
- Messages
- 102
I set a FilterOn on a form but in some instances this gives me no records (the filter works fine - it is just that in some instances there are no records to return). In this instance the result is that the form moves to a new record. I then check this with RecordCount (RecordCount = 0) and set the FilterOn property to False. The form shows "Unfiltered" but the records returned stay at 1 and do not return to the full number of records. I tried using Undo to clear the blank record which the form is waiting to have filled but this is not working.
When I clear the filter (FilterOn = False) how do I get the records returned to be the full number of records in the recordset? And how do I exit the expectation from Access that the user complete a new record?
When I clear the filter (FilterOn = False) how do I get the records returned to be the full number of records in the recordset? And how do I exit the expectation from Access that the user complete a new record?