Problem with record locking - forms w/subforms

[sohunter]

My Access database is "split" so that tables are in one file on the network, and there is copy of application at each user's computer, which is linked to these tables.

I have the various forms in the application set to "edited record" locking, so that only one person at a time can edit a record. The problem is, my main form has a subform on it. It appears that while one person is editing (or deleting?) the main record, somebody can be editing records on the sub-form.

So my question is...is there a way to simultaneously lock all subforms/records belonging to a main form/record?

 

[ROMBA]

lock the subform by locking each field of the subform ? Hope this helps.