Is there anyway I can tell BEFORE I type something into a field that the record is locked by someone else?

Thanks,
Laura

On Jul 29, 2:58*pm, musicloverlch <lho... (AT) gmail (DOT) com> wrote:
Take a look at Form.RecordLocks Property in Help. From the helo topic
it states "The following example sets the RecordLocks property of the
"Employees" form to Edited Record (a page of records is locked as soon
as any user starts editing any field in the record and stays locked
until the user moves to another record).

Visual Basic for Applications
Forms("Employees").RecordLocks = 2

On Jul 29, 2:58*pm, musicloverlch <lho... (AT) gmail (DOT) com> wrote:
I thought I replied to you yesterday but in Google you need to
validate the post by entering some meaningless word (I can never get
them right on a first time entry) in a validation box but obviously
didn't do so,

Anyway, Take a look at RecordLocks Property in Help.

Here's what it has to say "In a multiuser database, you can use the No
Locks setting if you want to use optimistic locking and warn users
attempting to edit the same record on a form. You can use the Edited
Record setting if you want to prevent two or more users editing data
at the same time.

The following example sets the RecordLocks property of the "Employees"
form to Edited Record (a page of records is locked as soon as any user
starts editing any field in the record and stays locked until the user
moves to another record).

Visual Basic for Applications
Forms("Employees").RecordLocks = 2"

You can test the above out and see if it does as advertised.