Zydeceltico
Registered User.
- Local time
- Today, 05:46
- Joined
- Dec 5, 2017
- Messages
- 843
Hi all -
Here's another one.
I have taken the suggestion of adding an InspectionType field in my main table, tblInspectionEvent which frmInspectionEvent is based on.
The values for InspectionType could be presented as a combobox with an attached Value List or pointing at a lookup table where I would have fields InspectionType_ID (autonumber) and InscpectionType (short text).
I've done this because I can now see how I could use that field later to build queries based on a specific type of inspection easier than trying to derive that from a more complicated query.
So - on frmInspectionEvent I have multiple buttons that open various inspection forms (e.g., Mill, WeldAssemble, Fabricate, Paint, etc).
If I add a textbox control to frmInspectionEvent, is it possible to code the form so that when one of the buttons is clicked to open a form that the textbox bound to InspectionType receives the InspectionType_ID associated with that specific "Open Form" button?
Something like:
If button "Mill Inspection" is clicked, InspectionType = 1
Else If button "WeldAssemble" is clicked, InspectionType = 2
Else If button...................
Is something like that possible?
Thanks,
Tim
Here's another one.
I have taken the suggestion of adding an InspectionType field in my main table, tblInspectionEvent which frmInspectionEvent is based on.
The values for InspectionType could be presented as a combobox with an attached Value List or pointing at a lookup table where I would have fields InspectionType_ID (autonumber) and InscpectionType (short text).
I've done this because I can now see how I could use that field later to build queries based on a specific type of inspection easier than trying to derive that from a more complicated query.
So - on frmInspectionEvent I have multiple buttons that open various inspection forms (e.g., Mill, WeldAssemble, Fabricate, Paint, etc).
If I add a textbox control to frmInspectionEvent, is it possible to code the form so that when one of the buttons is clicked to open a form that the textbox bound to InspectionType receives the InspectionType_ID associated with that specific "Open Form" button?
Something like:
If button "Mill Inspection" is clicked, InspectionType = 1
Else If button "WeldAssemble" is clicked, InspectionType = 2
Else If button...................
Is something like that possible?
Thanks,
Tim