C
Chris M.
I'm trying to use the OnDirty property on a form to
determine if the underlying record has changed. I want to
set a condition in a macro to display a msgbox "Are you
sure you want to update?" (but only if the record has
changed".
Using the expression builder, I select the form and the
property value, and the constant True or False. Access
gives me a type mismatch error. I have also tried setting
the expression to 0 or -1, per Access help on the OnDirty
property. I still get the type mistmatch.
How can I use the OnDirty property to determine if the
record has changed before applying the update?
I don't know VB and don't have time to learn it now...I'd
like to stick with Access and macros...
Chris M.
determine if the underlying record has changed. I want to
set a condition in a macro to display a msgbox "Are you
sure you want to update?" (but only if the record has
changed".
Using the expression builder, I select the form and the
property value, and the constant True or False. Access
gives me a type mismatch error. I have also tried setting
the expression to 0 or -1, per Access help on the OnDirty
property. I still get the type mistmatch.
How can I use the OnDirty property to determine if the
record has changed before applying the update?
I don't know VB and don't have time to learn it now...I'd
like to stick with Access and macros...
Chris M.
