update data in both form and subform

[patkeaveney]

I have a form which consists of several tabs.
The data for the form is selected by using a combobox to select the required record
2 of the tabs have a subform on them (each subform links to a different table which have their own add and remove buttons), the others contain data from the main form. The main form data is saved by using a save button.

When i change the data in one of the tabs linked to the main form then go to one of the tabs containing the subform, the subform appears to be locked, I cannot add or remove details from the subform.

If i go to the tab containing the subform first I can add remove data, but when i then go to a tab linked to the main form that is then locked.

The main table is linked to the subform tables via a link table

Is there a way I can add/remove data to the subform and update the main form in this single form.

Thanks
Pat

 

[sullyman]

When you change data in one of the tabs, is the record fully committed/saved first before you then go to the subform

 

[patkeaveney]

No the data is only saved when the user has made any changes to any of the tabs.
The user can move from one tab to the other making as many changes as they want. then click on save button to make changes permanent.

Following your question I have just run a test.
I added data to the subform, saved it by clicking on the add button, then went to a main form tag and I was able to change the data in a field, but when i went back to the subform tab the subform was locked.


Pat

 

[sullyman]

I am only a noob Pat but on my test project, i ended up creating 3 forms to make things easier for people.

One form for viewing records (View), one for editing (Edit) and one for adding (Add) new records. That way users easily could view, edit and add records

 

[sullyman]

When you changed data again in the main form, did you again save that record to fully commit it

 

[patkeaveney]

I use the same principle.
This forms allows the user to edit the data in the main form. I was trying to add the subform to the tag in this form to make it easier for the user.

I originally had a seperate form for the user to edit the subform data.

I cannot save the data for each tab seperatley.