Write Conflict Popup

[LDMueller]

Good morning,

I have Access 2003. I have a problem which I'm going to simplify in order
to explain it. I have two forms named frmNewTicket and frmExistingTicket.
Both of these forms had buttons which pointed to another form named
frmCloseTicket.

My problem is when doing it this way, I get a "Write Conflict" popup which
states "This record has been changed by another user since you started
editing it. If you save the record, you will overwrite the changes the other
user made. Copying the changes to the clipboard will let yo look at the
values the other user entered, and then paste your changes back in if you
decide to make changes. I then have to choose from three buttons, Save
Record, Copy to Clipboard, or Drop Changes.

Many times, I'm the only person in the database. What I've done to work
around this is I made a duplicate copy of the form frmCloseTicket and named
it frmCloseTicket1. I pointed the button on the frmExistingTicket to the
frmCloseTicket1 so no form will use the same form (if that makes sense).

This is a simplified explanation of what I'm doing, however I have multiple
forms with multiple buttons and having to copy and maintain duplicate forms
with different names seems like a lot of work and I'm hoping there is a
better way to handle this.

Any insight would be greatly appreciated.

Thanks!

 

[Joan Wild]

It is likely that your three forms all have the same recordsource. If you
edit something in frmNewTicket, and then open frmCloseTicket, you may be
creating a conflict since the edit on the first form hasn't been saved.

Try adding the following behind your buttons that open subsequent forms...

If Me.Dirty then Me.Dirty=False
'then your code to open other forms.

Also, just a comment, but it's unlikely that you really need two separate
forms frmNewTicket and frmExistingTicket. One form would likely do; just
open it differently depending on whether you want to add only or not.

DoCmd.OpenForm "frmTicket", , , , acFormAdd
would open the form to add records
DoCmd.OpenForm "frmTicket"
would open the form to edit records

 

[LDMueller]

Hi Joan,

I've done some preliminary tests and I think this may be the solution.

As far as your comment, I'll keep this in mind as I rework some of these
forms.

Thanks you so much!

LD