Jarichardusa
New member
- Local time
- Yesterday, 20:23
- Joined
- May 23, 2020
- Messages
- 19
so I have a filter set up on my main page to filter the results in a subform datasheet. I have a button to open another form to do some stuff, and when that form is closed I would like it to refresh the filter if it was already filtered before opening the secondary form up, essentially so the user will just be brought back exactly where they left from but with the new record showing, it it falls within the filter. But, if it wasn't already filtered, so there are no dates in the filter boxes, it fails with an error. What code is needed in order to essentially skip the filtering if the filter button is pressed but the fields are blank so that it just does nothing instead of erroring out?