Subform

[Bryan Hughes]

Hello,

I have a form for adding new client information with several page ctls.
Several page ctls have subforms on them. The subforms loaded after user
makes a selection. The main form and subforms are linked to the same table
and are all part of the new record being added. How can I link the subform
fields to the new client record on the main form?

Please Help
-Bryan

 

[tina]

-----Original Message-----
Hello,

I have a form for adding new client information with several page ctls.
Several page ctls have subforms on them. The subforms loaded after user
makes a selection. The main form and subforms are linked to the same table
and are all part of the new record being added. How can I link the subform
fields to the new client record on the main form?

Please Help
-Bryan


.
usually mainform/subform setup is as follows:

"parent" table bound to main form
"child" table bound to subform
why are you using subforms to enter data in the same table
that is bound to your main form? if you want
to "segregate" your main table's data fields into groups,
suggest you use a TabControl in the main form, and simply
put the field controls on different tabs as appropriate.
this design would not require subforms at all.
hope this helps.