Zydeceltico
Registered User.
- Local time
- Yesterday, 21:48
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
In the attached DB I have a form - frmInspectionEvent - which should be thought of as "the Main Form." It records Date/Time, Job number, and generates a primary key ID.
There are several tables linked to tblInspectionEvent via lnspectionEvent_PK in that table and InspectionEvent_FK in all of the linked tables.
On form frmInspectionEvent there are a few buttons. Each button opens a different type of inspection form as a popup. I do not want to do these in a tabbed control. I have already done that - it works great - but there is an obstacle "down the road" that I can see that makes this other idea more suited to my needs.
Clicking any one of the buttons opens a specific form whose linked table has a field that should record InspectionEvent_PK from frmInspectionEvent as InspectionEvent_FK.
The idea is that the user decides to do an inspection; opens frmInspectionEvent; makes selections; clicks "General"; enters details; closes "General"; clicks another button to open a more specific inspection form; enters data, clicks a "Save/Exit" button on the second form and everything closes with an entry made in tblInspectionEvent, tblInspectionGeneral; and an entry made in tblWhateverOtherInspectionFormWasSelected.
How do I do this?
How do I share the PK from the initial opening of frmInspectionEvent with whichever other forms are opened?
Thanks in advance!
Tim
In the attached DB I have a form - frmInspectionEvent - which should be thought of as "the Main Form." It records Date/Time, Job number, and generates a primary key ID.
There are several tables linked to tblInspectionEvent via lnspectionEvent_PK in that table and InspectionEvent_FK in all of the linked tables.
On form frmInspectionEvent there are a few buttons. Each button opens a different type of inspection form as a popup. I do not want to do these in a tabbed control. I have already done that - it works great - but there is an obstacle "down the road" that I can see that makes this other idea more suited to my needs.
Clicking any one of the buttons opens a specific form whose linked table has a field that should record InspectionEvent_PK from frmInspectionEvent as InspectionEvent_FK.
The idea is that the user decides to do an inspection; opens frmInspectionEvent; makes selections; clicks "General"; enters details; closes "General"; clicks another button to open a more specific inspection form; enters data, clicks a "Save/Exit" button on the second form and everything closes with an entry made in tblInspectionEvent, tblInspectionGeneral; and an entry made in tblWhateverOtherInspectionFormWasSelected.
How do I do this?
How do I share the PK from the initial opening of frmInspectionEvent with whichever other forms are opened?
Thanks in advance!
Tim