Form/Subform issues - linkage and visual

[mlandon99]

Current design:

Multiple tables and forms - Main form is "Contracts"

Have the following subforms: ContractingInfo, PayingInfo, ActivityLog, and LineItemDetails --- all are linked to the "Contracts" table with PK and FK

If, for example, I put the subform LineItemDetails directly onto the main form, the data is linked to the main form.

I don't visually like the subform on the main form however. I would prefer to have a button on the main form that will take me to the subform on a separate screen.

When I do this, the data on the subform is no longer linked to the ContractID on the main form (even though the PK from the main table is the FK on the subform table).

Question: how do I get the subform on a separate page and access it via a button on the main form and still keep the data linked?

 

[AlexN]

Does TabCtl help?

 

[spikepl]

You need to unconfuse yourself: a subform is a form which is embedded in another form. A stand-alone form is ... wait for it .. A FORM So there is no way you can point from a form to a stand-alone subform - no such thing.

As to how to open a form to some specific record from another form -look up DoCmd.OPenForm - plenty of examples online. And "keep data linked"? Again a form is a form is a form and no automatic linkage of any sort, other than what you make yourself.

Update: Define "keep data linked"