Changing a Yes/No field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top