I have a form to book in items which have arrived from a supplier. I have some common details such as date arrived, who received them. I also have a sub form with the list of actual items, with the fields specific to the individual items, such as cost, whether they were checked etc.
The problem is that as soon as I click on the sub form the main table record is saved automatically. I dont wont to save the main record until I can check that the sub form has been filled in correctly.
I can simulate what I want by removing the sub form and adding a button which opens the sub form for editing, this does not save the main record until I click save which is good. I want to do this using a subform as it keeps everything neatly on one form.
Can someone with more knowledge help me out?
Stu
The problem is that as soon as I click on the sub form the main table record is saved automatically. I dont wont to save the main record until I can check that the sub form has been filled in correctly.
I can simulate what I want by removing the sub form and adding a button which opens the sub form for editing, this does not save the main record until I click save which is good. I want to do this using a subform as it keeps everything neatly on one form.
Can someone with more knowledge help me out?
Stu
