Hi I am having real problems with this one.
I Have a form with a sub form. The main form is set against a table called contracts. The subform data is from a table called Parts.
The sub form is a continous form and holds a basic discription of all parts.
against each part is a button which closes the form down and opens a detailed form.
This form is called details and is linked to the parts table.
This form has a subform called materials. Whisch is linked to a table called Materials.
The problem I am getting is when I come to update values the parts table I keep getting an error in that the data is locked.
does any one have any ideas?
I Have a form with a sub form. The main form is set against a table called contracts. The subform data is from a table called Parts.
The sub form is a continous form and holds a basic discription of all parts.
against each part is a button which closes the form down and opens a detailed form.
This form is called details and is linked to the parts table.
This form has a subform called materials. Whisch is linked to a table called Materials.
The problem I am getting is when I come to update values the parts table I keep getting an error in that the data is locked.
does any one have any ideas?
