Filter causes NEW record to be inserted.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When the Filter criteria means no record/s are found a new record is inserted.

I want nothing displayed OR an error message OR anything else!
 
A new record is not created but the form does behave as if the 'New Record'
(navigation buttons) is pressed. This is very undesireable as an
inexperienced user might attempt to enter data and thus create a new record.

As I understand it, your method still allows a user to enter data into a new
record. Also I do not use autonumber.
 
Applying a filter to a form does not add a new record.
So it seems you have something else happening here.

Perhaps there is a macro or event procedure running in the form's Current
event that is the culprit?
 
Back
Top