Full Version: Test For Whether A Form Has Been Editted
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
Milster
Hello
Is there a function that will return a true/false for whether a form has been changed?
Thanks
lawmart
Do you mean the form's design has been changed? Or do you mean that the data on a form has changed?
doctor9
Milster,

Can you be more specific about what you're trying to do?

Are you referring to the actual design of a form? In that case, you may want to look at the .DateModified property of your form. That will tell you the date of the most recent change.

CurrentProject.AllForms("NameOfYourForm").DateModified

Hope this helps,

Dennis
Milster
Sorry. I meant when the data has changed whilst using a form. Not the design. I am aware of "Before Update" but just wanted to see if there was a function that could be called from a code module that returns a value for whether a change has happened or not.
Thanks
trapperalexander
check the .Dirty property of the form. there is also a Dirty Form Event which fires when the dirty property becomes TRUE.

hope this helps
Milster
You learn something every day. Thank you!
trapperalexander
glad we could be of assistance! good luck with your project thumbup.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.