new record won't allow input in subform

  • Thread starter Thread starter madwoman
  • Start date Start date
M

madwoman

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.


All suggestions appreciated

Many thanks
 
Until the record is saved to the main table, you won't be able to add any
info to your subforms. You could try adding a Save Record button on your
main form to see if that solves your problem. Depending on how the mainform
is created, such as Data Entry or Add, then the data has to be sent to the
underlying table. I would also check your Master/Child fields.
 
Many thanks, I think I have this sussed now.


G. Vaught said:
Until the record is saved to the main table, you won't be able to add any
info to your subforms. You could try adding a Save Record button on your
main form to see if that solves your problem. Depending on how the mainform
is created, such as Data Entry or Add, then the data has to be sent to the
underlying table. I would also check your Master/Child fields.
I have inherited a partially completed membership Access database which I
understand was originally generated from a load of linked FoxPro tables.
Click to expand...
[quoted text clipped - 26 lines]
Many thanks
Click to expand...
Click to expand...
 
Back
Top