How To set Up a Main Header form with details in the subform

[Anthony G via AccessMonster.com]

I do not know how to set this up.

I have a main form. I've split the form to have a header and detail section.
In the header form are the main or first 4 fields from the table and in the
detail section is more details. In the detail section i need to use a
subform because I'm changing the subform fields based upon the record type
chosen by the drop-down box of the main header. when i choose policy only
policy details will show up. when i chose reg only reg records will show up
in the detail subform.

The detail record will not be anactivity records so there is just one detail
records for the main header form. I'm only using the subform in the detail
because i need the form to change with the appropriate fields for that record
type from the combo box on the header.

Please help me with the best way to set this up to write out 1-(unique)
record.

I'm thinking the table will have all the fields, and the query will pull only
certain records to write to the table those fields.

Thanks,
Anthony

 

[TC]

Are all those fields in the same table? (That is, some of the fields
are used when the record type is 'X', others are used when the record
type is 'Y', and so on.)

If so, what you need is a tab control - not a subform. The tab control
can have several pages. You can put different filds (from the form's
base table) on each page of the tab control. You just have one page (in
the tab control) for each record type. The page for record type 'X'
would have the fields for that particular record type.

I'm not saying I think it is a good idea to have a table structure like
that. I'm just saying that if you /do/ have that structure, you'd use a
tab control - not a subform.

HTH,
TC