Getting runtime error 2448

G

Guest

I have two users, using same front end, that try to update the same record at
the same time. The last one in gets the runtime error message '2448', 'you
can't assign a value to this object'. I understand why I get the message,
record locking is turned on and the record is locked by the first user. Is
there a was I can trap this message message so I can inform the user taht the
record is locked and reset form?

Thanks
Larry
 
R

RuralGuy

You need to implement error handling:
Error Handling in VBA: http://allenbrowne.com/ser-23a.html

I have two users, using same front end, that try to update the same record at
the same time. The last one in gets the runtime error message '2448', 'you
can't assign a value to this object'. I understand why I get the message,
record locking is turned on and the record is locked by the first user. Is
there a was I can trap this message message so I can inform the user taht the
record is locked and reset form?

Thanks
Larry

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
R

RuralGuy

Glad I could help.

Worked, THANKS

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top