Update or CancelUpdate without AddNew or Edit

  • Thread starter AimeeK via AccessMonster.com
  • Start date
A

AimeeK via AccessMonster.com

Hello, all, I have a database form in which the user needs to use a combo box
to select a record for editing. Now, this combo box works when I first open
the form, and select each record from the combo box to make sure the form is
populating properly. But when I go back to select a record again, I get the
"Update or CancelUpdate without AddNew or Edit." This is driving me crazy.
I have no code in the BeforeUpdate Event of the form, just the AfterUpdate
Event of the combo box. It's as if I'm not allowed to select a record more
than once...I am new to VBA code, so any suggestions, please tell me which
events I should add code to for which objects...please help...thanks!!!
 

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

Dynamic Naming of Form Button 3
Trying to remove error from conflicting code 0
Clearing combo boxes and a text box 2
Update Or CancelUpdate without AddNew or Edit error 16
Creating a Search using a combo box and then creating a report. 4
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Optionbutton Not working 3
Error in Aceess form "Update or CancelUpdate without AddNew or Edit" 0

Top