Zydeceltico
Registered User.
- Local time
- Yesterday, 21:05
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
I have a main form that has a bunch of command buttons on it that open various types of data entry forms for various types of process inspections.
The main form is bound to tblInspectionEvent.
All of the various inspection forms each have an underlying table that is linked to tblInspectionEvent on field InspectionEvent_PK.
I also have another table called tblInspectionEventNotes to have all inspection notes related to the inspection event rather than the satellite inspection (one of the various types of inspections). This table is also linked on InspectionEvent_PK.
When you open the db, you are presented with a single command button: "Inspections." Clicking that will open frmInspectionEvent.
On that form you will see there are several more command buttons on the lower left and a single one on the right. The buttons on the lower left open inspections realted to welding, mill operation, assembly, etc. The single one on the right opens a form for line stops.
All of the inspection forms have an embedded subform - sfrmInspectionEventNotes. Clicking any of the command buttons on the left for any of those inspection types - everything opens perfectly and data is recorded as expected in all fields.
When I click "Line Stop," I receive a request for a parameter for tblInspectionEvents.Notes.
The thing is I embedded the subform in frmLineStop exactly the same way (I think) as I did for all of the other inspection forms. I've checked all of the "On Load" events and they are identical - unless I am too close to this to recognize the flaw that surely exists.
Hoping for a fresh set of eyes.
-----UPDATE - - which comes first: "On Current" or "On Load?"
Thanks!
Tim
I have a main form that has a bunch of command buttons on it that open various types of data entry forms for various types of process inspections.
The main form is bound to tblInspectionEvent.
All of the various inspection forms each have an underlying table that is linked to tblInspectionEvent on field InspectionEvent_PK.
I also have another table called tblInspectionEventNotes to have all inspection notes related to the inspection event rather than the satellite inspection (one of the various types of inspections). This table is also linked on InspectionEvent_PK.
When you open the db, you are presented with a single command button: "Inspections." Clicking that will open frmInspectionEvent.
On that form you will see there are several more command buttons on the lower left and a single one on the right. The buttons on the lower left open inspections realted to welding, mill operation, assembly, etc. The single one on the right opens a form for line stops.
All of the inspection forms have an embedded subform - sfrmInspectionEventNotes. Clicking any of the command buttons on the left for any of those inspection types - everything opens perfectly and data is recorded as expected in all fields.
When I click "Line Stop," I receive a request for a parameter for tblInspectionEvents.Notes.
The thing is I embedded the subform in frmLineStop exactly the same way (I think) as I did for all of the other inspection forms. I've checked all of the "On Load" events and they are identical - unless I am too close to this to recognize the flaw that surely exists.
Hoping for a fresh set of eyes.
-----UPDATE - - which comes first: "On Current" or "On Load?"
Thanks!
Tim