Check for other user

[RandyMyers]

Is there a way on a form/record to check to see if another user currently has focus on that particular record?

Basically, I want to see check if the record is currently being edited by one user when another user navigates to this record.

The reason why is that if one user creates a new record and is currently entering data (there are certain fields that require refreshes so the record is created) and another user opens the form and navigates to the previous record the required data verification will fire off and not allow them to navigate beyond this record.

Any thoughts?

 

[markphsd]

I think access has some sort of record locking in 2003, and maybe XP.

You could create a bunch of stuff to lock the reocd, but you should check out and see if record locking is available.

This problem seems like it's the way you are designing your forms, not really the record locking. maybe you need to set the form's allow edit's or allow add new record to false.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.