Software

Ask something
Discussion Locked

Access question

0 helpful
3 replies

by rcoolman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!!!

3 replies

by cptomlly

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

by rcoolman

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!

This discussion is closed to new replies.