Results 1 to 4 of 4
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496

    perplexed about an "Update... without AddNew..."

    There is one (1) field in a combobox on my form where if the user changes the entry once, they'll encounter no problems, but if they go to change its value a second time (that is without having saved the record after the first change by moving to another record and returning), they get this error:

    "Update or CancelUpdate without AddNew or Edit"

    It is frustrating themto no end; and on this... I am stumped
    (This does not happen with any ofthe other (many) fields / controls on the form... just this one


    I will take (with MANY thanks in advance) ANY suggestion whatsoever (truely... "anything"...)



    mark

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    What is, " one (1) field in a combobox"? I am not following ...

  3. #3
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I posted an answer, which seems to have disappeared
    Short version:
    - probably means a single column
    - have read where this can be fixed by a compact/repair
    - or there is code running in the wrong event
    - or it happens when form is linked to and ODBC source and the record is not saved before re-selecting (the combo may initiate an edit, or code behind it might be doing so).
    - if it's OK to save the record upon a new combo selection, do so in the (I think) BeforeUpdate event of the combo via
    If Me.Dirty = True Then Me.Dirty = False
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Is the combo box bound to a table field?
    What is the VBA code you have behind the combo box?

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

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  2. Replies: 1
    Last Post: 07-18-2015, 07:59 PM
  3. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  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