Clear Yes No Field

[pattlee]

I have a single form that is based on the table Categories and contains a
child table with a Yes/No checkbox. . Need to clear this field each time the
form is opened.. Where and how does this event happen? New to Access would
appreciate any help Thanks

 

[Golfinray]

Your checkbox should be tied to your table. If you haven't already, make a
field in your table, make the data type yes/no (in design view) and then tie
the checkbox to it. If you don't want to record a record of the checkbox,
then you just need an unbound checkbox and clear it each time you open the
form.

 

[pattlee]

The checkbox is in the table Products. This field is "checked" each time the
user identifies the type of product they need. There are multiple checks made
during each session. I am sending all checked items to a report so I need
the Checked items to remain open until I have completed the report. what I
need to do is each time the Form is opened for each session The field
"IsSelected" (the checkbox in the table Products ) to be False . Otherwise
the previous checks are still displayed. I have an update query that sets the
checkbox field to null. I just dont know where or how to associate the query
to the table Products in the Form. The form is a single form with a combo
box that looks up a Category and displays the table Products