OnDirty Property Type Mismatch

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.
 
A

Anthony Cravero

If me.dirty = true and
you.dirty = true then
me + you = intGoodTime

:)

Sorry, couldn't resist!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnDirty Not Firing 4
Strange OnCurrent error 7
Using timestamps for individual records on a continuous form 1
OnDirty Doesn't seem to be working 2
On Current Type mismatch error 3
Requesting Parameter Value on Update Query 2
Unbound Edit Box OnDirty Event Not Firing, OnChange Throwing Error 3
type mismatch in a form 3

Top