none
another user edited this record - message RRS feed

  • Question

  • 2013.accdb:  We have a form that is already so busy, unfortunately…. that to add an additional a long text field big enough to read and work in easily really is problematic in terms of the already crowded screen experience - and we would like to avoid moving to a tab control.... 

    As the field is only occasionally in play - the idea of a small button that opens a pop up form containing just the new field is a welcomed approach.  However this is triggering the message upon return into fields of the main form:

    The data has been changed. Another user edited this record and
    saved the changes before you attempted to save your changes.
    Re-edit the record

    The message is very understandable to me, and I can explain to users why it occurs - but I would like to eliminate it if possible.  There is no error number so not sure how to trap - - have played around with some dirty/false, requery, refresh at differing trigger event points but haven't been able to get a handle on this.  Would welcome input & advice.  thanks.

    Monday, August 27, 2018 1:37 PM

Answers

  • Hi,

    how about making the pop up form unbound, use VBA to fill it on open and on close send the result back to the record in the "mother" form?


    Karl
    http://www.AccessDevCon.com
    http://www.donkarl.com

    Monday, August 27, 2018 1:45 PM
  • As the field is only occasionally in play - the idea of a small button that opens a pop up form containing just the new field is a welcomed approach.

    Hi msdnP,

    On every form I have a Zoom-button. Clicking the Zoom-button opens a (unbound) Zoom-form, with one control large enough to hold the value of the referring control. This control has the same editability as the referring control. After update and closing the form the referring control is updated. This is the same as Karl suggests.

    Another way that I use is to set the conrol's StatusBarText with the first 255 characters of its value in the Enter event.

    Imb.

    Monday, August 27, 2018 2:33 PM

All replies

  • Hi,

    how about making the pop up form unbound, use VBA to fill it on open and on close send the result back to the record in the "mother" form?


    Karl
    http://www.AccessDevCon.com
    http://www.donkarl.com

    Monday, August 27, 2018 1:45 PM
  • As the field is only occasionally in play - the idea of a small button that opens a pop up form containing just the new field is a welcomed approach.

    Hi msdnP,

    On every form I have a Zoom-button. Clicking the Zoom-button opens a (unbound) Zoom-form, with one control large enough to hold the value of the referring control. This control has the same editability as the referring control. After update and closing the form the referring control is updated. This is the same as Karl suggests.

    Another way that I use is to set the conrol's StatusBarText with the first 255 characters of its value in the Enter event.

    Imb.

    Monday, August 27, 2018 2:33 PM
  • thanks - should have thought unbound...  will give it a shot
    Monday, August 27, 2018 4:14 PM
  • appreciated - going to give unbound a try
    Monday, August 27, 2018 4:14 PM
  • Another approach would be simply to save the main form (if it's dirty) before you open the popup, and refresh it after the popup closes.  Then you won't have a conflict.  E.g,

        If Me.Dirty Then Me.Dirty = False
        DoCmd.OpenForm "frmYourPopup", WindowMode:=acDialog
        Me.Refresh


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html


    Monday, August 27, 2018 4:17 PM