Access 2007 Issue

[Mary Fetsch]

I have an Access 2003 adp that I'm converting to Access 2007. I'm adjusting
the record source of a form using Visual Basic. In version 2003, this didn't
change the record source in the actual form. In version 2007, there are
conditons where the record source in the actual form is being changed - when
I close the form, I'm asked if I want to save the form changes. This is a
problem because I never want the user to save form changes. I don't want the
form's actual record source changed. Is there an option I can set so that
form changes aren't allowed? Or is there something else I can do? Thanks!

 

[Jeanette Cunningham]

Hi Mary,
in the code that closes the form, you can use

DoCmd.Close acForm, Me.Name, acSaveNo

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Mary Fetsch]

Thanks for your quick response, Jeanette. I don't close the form using VB.
The user can enter as many records as she wants before closing the form. So
the user controls when the form should be closed and then clicks the form's X
or clicks File Close. I seems to me that the only way I can control the
closing is to have a Close button on the form. Or do you have a better idea?

 

[Jeanette Cunningham]

Try it with a close button and disable the form's X.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Mary Fetsch]

Thanks for your help with this, Jeanette.

Try it with a close button and disable the form's X.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia