p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Form ALWAYS asks to save changes (http://p2p.wrox.com/showthread.php?t=22093)

mmcdonal December 3rd, 2004 02:56 PM

Form ALWAYS asks to save changes
 
Hi,

   I have a form that I have been using in Access for some time. Lately it is asking me if I want to save changes to the form each time I close it. I am not making any changes to the design of the form.

   I thought it might be that the form is trying to change the underlying table, which is linked to a back end, and the changes are never saved (because it's linked.) How would I resolve this, other than to recreate the form?

Thanks,


mmcdonal

Clive Astley December 4th, 2004 07:51 AM

Hi Michael,

Just a thought. Are you sure you are not making any subtle changes to the form? Such as changing a label's caption or some module code? I have come across this in the past but can't remember what it was - it was something changing that I didn't at first realise.

Hope this helps,




Clive Astley

mmcdonal December 7th, 2004 09:48 AM

I realized it was the subform asking me to confirm changes. The subform was an autoform, and I think what I did was change the underlying table slightly, and then the autoform is trying to change it back. Since it is on a back end, it can never do this. So I removed the autoform subform and rebuilt it from scratch and it works fine.

Thanks for pointing me in the right direction, although "bostek" might email you and tell you "look, if you do not have sense answer try not to respond" as he did to me when I posted a similar attempt to point someone in the right direction. [xx(]



mmcdonal

Clive Astley December 7th, 2004 11:58 AM

Glad you found a solution. Have not come across "bostek" but that sort of remark doesn't seem in the spirit of this forum. I've been helped numerous times with a simple solution which I had overlooked because I had got bogged down with looking for something more complicated, or the mindset had wandered in the wrong direction. This community is all about self-help and long may it exist.

Best wishes,


Clive Astley


All times are GMT -4. The time now is 07:31 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.