Results 1 to 2 of 2
  1. #1
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112

    Combo box causes "Update or cancel update without AddNew or Edit"

    I have a form with an unbound combo box designed to search for a record, pulling its fields from a query. Then, the form has a number of fields, based on the same query, that may be edited.



    I can do the editing in the query, and in the body of the form unless I locate the record with the combo box, then I get the error message mentioned in the title to this question.

    If I search for the record with the little search window at the bottom of the form, I do not have the problem, so it does seem related to the combo box.

    Any help would be appreciated!

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What is the VBA code behind the combo box?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update or CancelUpdate without AddNew or Edit
    By westcoastbmx in forum Forms
    Replies: 5
    Last Post: 11-07-2019, 09:01 PM
  2. Replies: 5
    Last Post: 06-12-2015, 02:15 PM
  3. Replies: 8
    Last Post: 07-15-2014, 05:56 PM
  4. Replies: 9
    Last Post: 04-01-2011, 10:31 AM
  5. Replies: 3
    Last Post: 03-07-2011, 08:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums