Results 1 to 2 of 2

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

  1. #1
    louise is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    74

    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
    8,247
    What is the VBA code behind the combo box?
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 5
    Last Post: 06-12-2015, 02:15 PM
  2. Replies: 8
    Last Post: 07-15-2014, 05:56 PM
  3. Replies: 9
    Last Post: 04-01-2011, 10:31 AM
  4. Replies: 3
    Last Post: 03-07-2011, 08:37 PM
  5. Update or CancelUpdate without AddNew or Edit
    By westcoastbmx in forum Forms
    Replies: 3
    Last Post: 11-12-2009, 05:07 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
  •  
Tech Forums: Microsoft Office Forums