General discussion


Access question

By rcoolman ·
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!!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by CptOmlly 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

Collapse -

by rcoolman In reply to

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!

Collapse -

by rcoolman In reply to Access question

This question was closed by the author

Related Discussions

Related Forums