I have a database with approx. 15 tables and 7 forms. My main form "contracts" is for the general information about the contract. I then have several "subforms" such as Paying office info, Activity Log, Line Item Details, etc. If I put the subform on the main form, it looks terrible but functions okay. What I really want, however, is to be able to have a button on the main form that will take me to the subform on its own screen. Then, when you're done filling in the info on the subform, I have a button that saves that form and returns you to the main form where you can then click a button to access a different subform. The only time I want it altogether is in a report view. Here's the problem. When the subform is on a separate screen accessed by a button on the main form, the data is not linked to the main form. In other words, no matter what contract record I view on the main form, when I go to the subform the data there is for the first record I entered. Sorry if that's confusing. How do I visually achieve having the subform separate from the main and still have the data between the two linked?
Subform issue
- Thread starter mlandon99
- Start date
Let me try this again --- 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?
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?
spikepl
Eledittingent Beliped
- Local time
- Today, 03:17
- Joined
- Nov 3, 2010
- Messages
- 6,142
Double posting really puts you in the doghouse! 
Don't!
This post is doubleposted http://www.access-programmers.co.uk/forums/showthread.php?t=271479 and the discussion continues there.
FYI: read this about doubleposting/crossposting: http://www.excelguru.ca/content.php?184
Don't!This post is doubleposted http://www.access-programmers.co.uk/forums/showthread.php?t=271479 and the discussion continues there.
FYI: read this about doubleposting/crossposting: http://www.excelguru.ca/content.php?184