Form and several subforms

  • Thread starter Thread starter Irina
  • Start date Start date
I

Irina

Hello,
I am wondering if this can be done.
I have a form and several subforms, I want to have the user type in all the
informatioon into the form and subforms (that are tabs on the main form)
and all the information is stored in the same table.
Right now only the information user types into the main form gets saved to a
table
the information that is typed into subforms is not getting stored.
How do I get it to store in the same table?? All subform fields are the same
as the ones in the table. Subforms and the main form are not linked.
Please advise if this can be done.
 
Hello,
I am wondering if this can be done.
I have a form and several subforms, I want to have the user type in all the
informatioon into the form and subforms (that are tabs on the main form)
and all the information is stored in the same table.
Right now only the information user types into the main form gets saved to a
table
the information that is typed into subforms is not getting stored.
How do I get it to store in the same table?? All subform fields are the same
as the ones in the table. Subforms and the main form are not linked.
Please advise if this can be done.
Click to expand...

I'm sorry, this is making no sense. You have a single table? and you have form
and subform controls which should be updating the SAME field in the SAME
record?

Normally a Subform construct is used to update *two* tables in a one-to-many
relationship. The mainform is used to update the "one" side table; the subform
to update the related "many" side table; the subform's Master/Child Link Field
properties define the foreign key link between the tables.

What is the structure of your table?
What is the Recordsource property of your form?
Are you actually using Subform controls (a box containing a Form object based
on a query), or are you just calling tab pages "sub forms"?
If you are using Subforms, what is the Recordsource property of one or two of
them?
Are the controls for which values are not being saved bound, that is, do they
have a Control Source property?
 
Back
Top