Changing a Yes/No field

[manos]

I have a yes/no field called "Printed" in my datadase that i want to change
every time a button is pressed to print a report in order to know whether it
has been printed or not.

can anyone help me please?

 

[Alex Dybenko]

In a event procedure on this button run an update query, like following:

currentdb.execute "Update MyTable Set Printed=-1 where <some confdition to
point to current record>"

or you can just set control value if it is on the same form

me!Printed = true