I have a database in which there is a data capture form.
The main part of this form captures a CONTRACT number (along with some other details) and it then has a subform which captures individual data relative to each contract.
I want more than 1 use to enter detail on the subform but at the moment when 1 user has the form open, no -one else can access it because of the warning message which states it cannot lock the tables which drive the form.
Is there a solution to this ?