Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Can't edit/add data in subform (http://www.go4expert.com/forums/edit-add-data-subform-t1071/)

madwoman 27Jul2006 01:13

Can't edit/add data in subform
I have inherited a partially completed membership Access database which I
understand was originally generated from a load of linked FoxPro tables.
There is a form which uses multiple tabs, the first tab contains general
membership data (ie name, age etc) and this pulls data through from the
'Main' table in the database. Each of the other tabs includes a subform which
shows data held in a number of different tables linked to the 'Main' table
(eg, first tab - general data from 'Main table', 2nd tab - home addreses
from 'Home Address' table, 3rd tab - business addresses from 'Business
Address' table). All tables are linked to the 'Main' table through a common
'RegisterID' field. When I open the form I can query on any of the records
and amend and items of data on the various tabs them without any problem.
However if I add a new record using the >* option from the record navigation
I can add data to the first tab (ie. into the 'Main' table) but if I move to
the 2nd or 3rd tab I am unable to edit/add data to the fields on those tabs.
But if I save the record after completing the fields on the first tab and
then close the form and reopen it I can then edit the 2nd and 3rd tabs, can
you suggest how I can change the setup to allow editing/adding data to the
2nd and 3rd tabs without having to close the form and reopen it please. I
have checked the subforms and they are set to AllowEdit and there are NoLocks.

shabbir 27Jul2006 11:14

Re: Can't edit/add data in subform
This happens because there is a relationship in the data among the tables on the first tab and other tab. Something like

Student Roll No is on first tab and marks in other tab.
Unless you save the roll no to the tables you cannot have marks added to the corresponding tables.

Instead of removing such relationship I would suggest to have a button to save the data in the first tab.

madwoman 27Jul2006 23:28

Re: Can't edit/add data in subform
Many thanks, I think I have it sussed now.

shabbir 28Jul2006 11:04

Re: Can't edit/add data in subform
My pleasure.

All times are GMT +5.5. The time now is 00:05.