Hey all.
Access initiate here.
I have a command button that runs a macro in the Header of a Main Form:
OpenForm Switchboard, Form, , , , Normal
Close Form, MainForm, Prompt
StopMacro
It does what I want it to do - a button that closes the Main Form, and opens the Switchboard. The problem is the Main Form has default values. Whenever that button in the header is clicked, it saves the default values as a new record with no prompt.
Essentially, I want to click the "Open Switchboard" button, then have a prompt notifying me that there is unsaved data on the Form (which would be either default data, or a record that I was working on). I'd like to option to Save the record and continue, Don't Save the record and continue, or Cancel opening the Switchboard Form.
How's this accomplished?
Thanks!
Access initiate here.
I have a command button that runs a macro in the Header of a Main Form:
OpenForm Switchboard, Form, , , , Normal
Close Form, MainForm, Prompt
StopMacro
It does what I want it to do - a button that closes the Main Form, and opens the Switchboard. The problem is the Main Form has default values. Whenever that button in the header is clicked, it saves the default values as a new record with no prompt.
Essentially, I want to click the "Open Switchboard" button, then have a prompt notifying me that there is unsaved data on the Form (which would be either default data, or a record that I was working on). I'd like to option to Save the record and continue, Don't Save the record and continue, or Cancel opening the Switchboard Form.
How's this accomplished?
Thanks!