Record Locking

[Martin]

I have a "main" form that a user can select a physician to review from an
unbound combobox. After selecting the physician, the user clicks a button
for the desired subset of information that needs to be edited (specialties,
offices, etc). Each of these subsets is displayed by another form that
selects the information from the appropriate table based on the physcian
selected in the main form. I want to make sure that the information in the
subset is not edited by another user.

Will setting the RecordLocks property of the main form to Edited Record be
sufficient to lock the subsets? Or do I need to set the RecordLocks property
of each of the subset forms instead/in addition to the main form?

Also, the subset forms display multiple records for the selected physician.
I am confused about the RecordLocks setting of All Records. Will that lock
all the records selected by the form (which is what I would like) or lock the
entire table (which would prevent another user from working with another
physician's info)?

Thanks in advance for the help.