Clear check boxes on an Access Form automatically.

  • Thread starter Thread starter geo
  • Start date Start date
G

geo

I would like to use the "OnLoad" Property to clear checkboxes on a Form
automatically when it opens. Any ideas?
 
I would like to use the "OnLoad" Property to clear checkboxes on a Form
automatically when it opens. Any ideas?
Click to expand...


Your check box is bound to a table field so you need to run an update
query:

CurrentDb.Execute "Update MyTable Set MyTable.CheckName = 0;",
dbFailOnError

You will need to have a library reference set to the
Microsoft DAO 3.6 Object Library.
Open any code window. Click on Tools + Reference.
If you already have a reference to the above library set you don't
have to do anything. If the reference is not checked, scroll down the
list until you get to it. Place a check in the check box. Save the
change.
 
Good Assist, Thanks Fred!

fredg said:
Your check box is bound to a table field so you need to run an update
query:

CurrentDb.Execute "Update MyTable Set MyTable.CheckName = 0;",
dbFailOnError

You will need to have a library reference set to the
Microsoft DAO 3.6 Object Library.
Open any code window. Click on Tools + Reference.
If you already have a reference to the above library set you don't
have to do anything. If the reference is not checked, scroll down the
list until you get to it. Place a check in the check box. Save the
change.
Click to expand...
 
Back
Top