Clear Yes No Field

  • Thread starter Thread starter pattlee
  • Start date Start date
P

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
 
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.
 
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
 
Back
Top