Edited Record on Form

[Arlend Floyd]

I have a fe and be in a muti user envierment using access 2002 working from
remote locations. I set the forms Record locks to "Edited Record" all works
great. Question is when that form is locked due to editing how can I display
user name to the second user by MsgBox. Currently there not geting any info
other then record cant type any data.

Some same code would be nice. thanks

 

[strive4peace]

Hi Arlend,

try using dLookup

if you need help using dLookup, please tell us your table name and
fieldname and condition to decide what record to show

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*