Hi,
I have a front end form with 2 child subforms. Multiple people are performing data entry or running queries against the backend. I had no record locks and inevitably we ran into problems. (This is not really my regular job - just an application I have had to develop for a specific project.) I'm having trouble figuring out the record locks: if I set the record locks property to "edited record" for both the form and subform , it seems to prevent users from simultaneously editing a record on the main form, but not the associated child records. How can I lock the record and the linked child records? I have tried setting the subform property 'Locked' to Yes, but that locks all of the subform records, even those not associated with the parent record. I think this should be simple, I'm just new at this and under time crunch. THanks so much for any help, it is much appreciated.
I have a front end form with 2 child subforms. Multiple people are performing data entry or running queries against the backend. I had no record locks and inevitably we ran into problems. (This is not really my regular job - just an application I have had to develop for a specific project.) I'm having trouble figuring out the record locks: if I set the record locks property to "edited record" for both the form and subform , it seems to prevent users from simultaneously editing a record on the main form, but not the associated child records. How can I lock the record and the linked child records? I have tried setting the subform property 'Locked' to Yes, but that locks all of the subform records, even those not associated with the parent record. I think this should be simple, I'm just new at this and under time crunch. THanks so much for any help, it is much appreciated.
