Message that another user has modified the record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I am sending an e-mail from a button; after that 2 fields are updated from
an update query; the record is not updated until I click 'drop changes' on
the message that tells that another user modified the record (but nobody is
in in the database).

I have tried all the 3 options of the record locks

What else should I try?

Thanks,

Dan
 
I also had a problem similiar to this and the fix I needed to so was to save
the record before the update query ran.

If that doesn't work then you can also dim a variable instead of an update
query use a Dlookup to update the field (if that is possible).

Hope this works for you.

Stephanie
 
Back
Top