I have a list box on a form from which the user can select a record. I've set up the ability to filter the list box. This does not filter the form's recordset (at least not currently).
Sometimes the filter may return an empty list. If that happens, I'd like the main form to remove the record selection and empty out all the form fields. The user cannot create new records from this form, so it can't move to a new, blank record.
Is there a way to do this?
Sometimes the filter may return an empty list. If that happens, I'd like the main form to remove the record selection and empty out all the form fields. The user cannot create new records from this form, so it can't move to a new, blank record.
Is there a way to do this?