If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
new record won't allow input 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. All suggestions appreciated Many thanks |
#2
|
|||
|
|||
new record won't allow input in subform
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. "madwoman" u24541@uwe wrote in message news:63d40ef79ab81@uwe... 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 |
#3
|
|||
|
|||
new record won't allow input in subform
Many thanks, I think I have this sussed now.
G. Vaught wrote: 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. [quoted text clipped - 26 lines] Many thanks -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|