By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,231 Members | 1,707 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,231 IT Pros & Developers. It's quick & easy.

When using macro to close form, how do I force the 'prompt' on save?

100+
P: 167
I have an MS2007 access database. On one of the forms that is used to edit/change data, there is a button 'Return to main menu'. Once the user has finished making the changes on the form and clicks on this button, it runs a macro to close the form and open the main menu form. On the 'close' form it has the has the following:

Object Type: form
Object Name: DataEditInventory
Save:Prompt

From what I have read about the 'Save:Prompt', when the form is closed, it should prompt the user if they want to save the changes. However, no prompt is being displayed. I am not familiar with using macros to close forms. Any ideas as to why this isn't doing the 'prompt'?
May 2 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.