How: form to update other form?: Write Conflict Error

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a field in my main form that I am trying to update
using a seperate form.
I followed the help examples in Access 2k to create a
Macro that's attached to a command button on that second
form to update the main form. And it appears to work
properly initially.

But then when I try to go on to the next record. I get an
error message stating:
Write Conflict.
Another user has edited this record. Do you want to drop
the changes.....blah,blah blah.

If I choose drop changes. Everything is again ok. Until I
try to edit the field with the remote form a second time.
At this point my Macr crashes the database and gives me a
Macro Halt error.

So much for the MS Access help examples being helpful. ;-)

Obviously I'm doing this wrong.
Can anyone tell me the proper way to update a field on the
main form with a seperate form?


-Scott
 
It sounds like both forms may have the same table open,
that could cause a conflict. If I were you, I'd use code
rather than a macro, that way you can trap and debug it,
rather than just getting a halt. For example, code in
the on click event for the command button :

forms!firstForm!fieldname1 = forms!secondform!fieldname2

or something of that sort.
 
Back
Top