Adding data to the main table via a sub form and viewing it on the subform

[HelenM]

Hi I have a set of subforms in a tabbed control. Each is based on a separate/linked one-to-many table and works OK. The database is a list of tasks and each task can have 0, one or many flights. The flights are thesefore in a sub form. However, there is a required field for that is a comment on all the flights. This comment field is therefore one to one and is in the main table. I need to have this comment on the same tab as the flights but can't seem to make it updatable. I've tried putting a control on the task tab and making it invisible, then referencing it from the flights tab, this displays but is not updatable. I've tried referencing the field in the table directly [Task Core Data]![Flight(s) Additional Comments:], but that just comes up with #Name. Do I need to base the subform on a query instead of a table?

[davegri]

As I understand it, you want the same comment field to appear on all the tabs. To do this, you can put the comments textbox in the detail section of the main form under the tabs, not on the tabs. It will show "through" on all the tabs.

[NTC]

in addition to the first reply; to be updateable the form's field must be bound directly to the table's field. In a form one can have multiple text fields bound to the same table field. Just add the first and then copy it. Then you can enter into any and they all change....

For a field to be in the tab of a tab control then you have to shoe-horn it in with the sub form that sits there now. But it is very do-able. Working in tab controls such as adding a field takes a little getting use to - you have to get the hang of highlighting the sub frame and such......