Search results

Thanks to both of you for responding so quickly. Both solutions leave me with a form with an empty recordset, which results in "#Name?" in all my form fields. For now at least, I think I'll be better off preventing selection of a filter that returns no records. Thanks again.

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...