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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
VBA: How can I use a string variable as autofilter criteria? 4
Filtered Records as source for appending records to a table 1
stLinkCriteria 2
Combo box filter before form opens 1
Record Level Filtering 4
Filter Record Count 3
Filtering and Removing Filter based on a combo box 4

Back
Top