Update or CancelUpdate Error

C

C. Sharp

I have a user who is getting the "Update or cancelUpdate without addNew or
edit." error message 3020 on a data entry form. This happens when the user
first Filters for an attendee type = XXX. Next, my colleague selects the
last name field and depresses CTRL+F to find a record by last name. BUT if
my user mispells the name twice in a row the error above pops up. Any idea
why this error would pop up? We have not VBA code on this very generic data
entry form. Thanks in advance for suggestions!
 
A

Arvin Meyer [MVP]

The table is most likely assuming data input and is reacting to incorrect
operating or validation.

Use combo or list boxes for your variable data entry, with NotInList event
code to handle data which needs to be added. Form filtering is done to find
records, not enter them.
 

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

Update or Cancel Update Error 3
error message 3020 "Update or CancelUpdate Without Addnew or Edit" 3
How to Solve Update or Cancel Update Without Addnew or Edit Error 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Update or CancelUpdate without AddNew or Edit - ? 2
Combo box assigned to a field not working 1
Update or cancel update without addnew or edit error -2147352567 1
3020: Update or CancelUpdate 1

Top