By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

how to tell if a form has been changed?

P: n/a
is there a way to tell how a form has been changed?

I want a button that will close the form and undo anything if detected to
avoid having two buttons, one for undo and then one for close.

what would go in the ???

if me.??? = true then
docmd ...acUndo
docmd.close
exit sub
end if

docmd.close

apparently there are checks in place now as I can't use the above if no
changes have been made
thnx
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Steve, I think you need: If Me.Dirty Then ...

Be aware that your record will be automatically saved in many ways ... (subforms will be a problem)
That is just the way Access works by default.

Use unbound forms and add the data via append-query's if you want to ...
Or use a form where the recordsource is a snapshot (form = read-only)
Or open the form as read-only.
Or ?

Arno R

"Steve" <1@2.com> schreef in bericht news:Xm*****************@newsread1.news.atl.earthl ink.net...
is there a way to tell how a form has been changed?

I want a button that will close the form and undo anything if detected to
avoid having two buttons, one for undo and then one for close.

what would go in the ???

if me.??? = true then
docmd ...acUndo
docmd.close
exit sub
end if

docmd.close


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.