Software·43,733 discussions

Access question

Locked

Probably a simple question for someone:
Say you have an Access database (2000 – 03) with one table T1 and a form F1 which displays all of the data in T1 and is editable. Say T1 has a field that is of type check box. How can I put a command button on F1 that will clear the check boxes for all the records? Please keep the answer simple – am fairly new at this Access stuff. – Thanks!!!

Topic

Reply To: Access question

In reply to Access question

You can do this with an update query. Create an to create an update query, select “Create Query in Design View”. Select T1 as the table to include. Right click on the query design window, and choose “Query Type>Update”. Then choose the checkbox field and in the update box enter “false”. Then simply call this query from your command button Click() routine.

Hope this helps

Reply To: Access question

In reply to Reply To: Access question

Thanks! That does the trick! I am trying to learn Access and its amazing what is intuitive, but I hadn’t even noticed that there were other query types. Thanks again!

Reply To: Access question

In reply to Access question

This question was closed by the author

[Author]

Replies