Jan 7 2011, 03:55 PM
Is there a function that will return a true/false for whether a form has been changed?
Jan 7 2011, 04:32 PM
Do you mean the form's design has been changed? Or do you mean that the data on a form has changed?
Jan 7 2011, 04:35 PM
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.
Hope this helps,
Jan 7 2011, 04:44 PM
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.
Jan 7 2011, 04:51 PM
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
Jan 7 2011, 05:00 PM
You learn something every day. Thank you!
Jan 7 2011, 05:31 PM
glad we could be of assistance! good luck with your project l-align:middle" emoid=":thumbup:" border="0" alt="thumbup.gif" />
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here