another user edited this record - message

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.

Answer 1

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

Answer 2

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.

Answer 3

thanks - should have thought unbound...  will give it a shot

Answer 4

appreciated - going to give unbound a try

Answer 5

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