How to use checkboxes

[snypa]

Hi Guys

how can I use these checkbox to determine what fields to update from this table. ie I want to write a control statement that will update a certain field if the checkbox is checked and not update that field if its not. I have four fields that can be updated in any combination according to the checkbox selection

Thanx in advance

 

[John Big Booty]

You will need to add a Yes/No field to your table. Set the default to No. Now you can create an update query that uses the Yes/No = Yes (True or -1) as part of it's criteria.

Remember you will also need to create another update query to set the Yes/No back to No (False or 0) once you have run your initial update query.