GAK34nj
New member
- Local time
- Today, 02:58
- Joined
- Jul 28, 2020
- Messages
- 5
I have a variety of buttons which I've placed in the header areas of my forms. Depending on the form, some or all of the buttons are placed on the header.
There are the buttons:
Anyway - The code for these operations is repeated on -each- of the forms these buttons are found on. I'd love to place the entire bit in a module, pass a parameter value to the module, and have the module take action. It raises questions though! Can you save a record on a form and/or close the form from a module -outside- the form itself? Moreover, can you exercise those operations, -not- close the form, and then return to it to do things like requeries and other continued work / data entry?
I'm fantasizing about a solution but my pathetic ineptness at scripting makes it very elusive indeed. Any help here would be immensely appreciated.
With thanks,
Gary
There are the buttons:
- Save, Add New Record - label: SAVE | ADD
- Save, Continue Editing - label SAVE | EDIT
- Save, Close Form - label SAVE | QUIT
- Quit Form (No Save) - label NO SAVE | QUIT
Anyway - The code for these operations is repeated on -each- of the forms these buttons are found on. I'd love to place the entire bit in a module, pass a parameter value to the module, and have the module take action. It raises questions though! Can you save a record on a form and/or close the form from a module -outside- the form itself? Moreover, can you exercise those operations, -not- close the form, and then return to it to do things like requeries and other continued work / data entry?
I'm fantasizing about a solution but my pathetic ineptness at scripting makes it very elusive indeed. Any help here would be immensely appreciated.
With thanks,
Gary