T
Theresa
I have a main form "Projects" which contains a tab control with 5 tabs, each
containing a different subform. Each subform is in datasheet view, tied to
the main form by the project id and have several records for each project. I
would like to pull certain fields from the first subform onto another
subform. I tried including these fields in my query, but the query becomes
non-updatable. If I create an unbound text box on my subform and reference
the original form, my dataset becomes non-updatable.
In short, I have a main Projects form containing basic information. I have
a subform which identifies "Areas" along with other information. I have
another subform, on another tab, where I would like the "Areas" to populate
automatically.
Can anyone tell me how to do this.
containing a different subform. Each subform is in datasheet view, tied to
the main form by the project id and have several records for each project. I
would like to pull certain fields from the first subform onto another
subform. I tried including these fields in my query, but the query becomes
non-updatable. If I create an unbound text box on my subform and reference
the original form, my dataset becomes non-updatable.
In short, I have a main Projects form containing basic information. I have
a subform which identifies "Areas" along with other information. I have
another subform, on another tab, where I would like the "Areas" to populate
automatically.
Can anyone tell me how to do this.