>I am trying to alert users about locked records before hand so that they dont try to edit that particular record. If they still try then it prompts that record is locked. I am using TRANSACTION to carry out these edits. Parent table, which is edited, has pessimistic buffering.
Norman,
Normally, edit rights to a field linked to a form control are taken care of at the control level.
In this case, if the control determines that its controlsource field in in a locked record (or table), it should set itself to .readonly or not .enabled, or prevent the user from gaining access by returning .F. from when().
regards.
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.