Hi! This may be a simple thing, but I can't figure it out. I have created a
continuous form. There is a check box field (which is bound to a table) that
I want to clear every time I exit the form. I created an update query to
update to no when the criteria was yes...but do not know where to go from
there. Any thoughts or suggestions?
CurrentDb.QueryDefs("NameOfUpdateQuery").Execute dbFailOnError

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Hi! This may be a simple thing, but I can't figure it out. I have
> created a
[quoted text clipped - 3 lines]
> update to no when the criteria was yes...but do not know where to go from
> there. Any thoughts or suggestions?