How do I control Access form filter if no records found?

[DougieJ]

I have a form which allows the usual filtering by the user. For example, the user can right-click a displayed field and select 'Text filters'...'Equals...' and type a target string. This works fine if the target string is found, but if it is not the form goes into (New) record mode. The same thing happens if I try to place a filter on the table for a non-existent value - it moves to the 'add record' line. This has only recently begun to happen, and doesn't happen always. The form shows an editable dataset but disallows additions. Is there any way I can intercept the filter and have a meaningful message displayed if no match is found for the target string or number? I know I can work around by writing my own search code, but I'd rather use the Access front end as it is.

[DougieJ]

This appears to be a bug in Access 2010. If a filter returns an empty dataset, then a blank screen should be displayed when 'Allow Additions' = No in the form properties, otherwise a new record. However, intermittently a form with 'Allow additions' =No will return a new record instead of a blank form.

[ItsMe]

That is going to happen if the form's properties do not allow additions or the form's recordsource is not updatable. Perhaps you can instruct the users to remove the Filter via the "Toggle Filter" tool.