unbound Checkbox

[Connie]

I'm trying to create a form that will display a list in datasheet view where
the user can check those records they want to send a letter. If I add an
unbound checkbox to this form, when the user checks 1 box it checks it for
all records. Is creating a temp table (& base the query for this form off
that temp table) the way to go or is there a better way to accomplish this.

TIA
Connie

 

[Rick B]

You need to add the checkbox field to the table and store the value. How
else would access track which records were or were not checked?

I'd include some type of "uncheck all" button with code to reset all the
checkboxes after you do your letters.

 

[Connie]

ok that's what I thought.
Thanks

You need to add the checkbox field to the table and store the value. How
else would access track which records were or were not checked?

I'd include some type of "uncheck all" button with code to reset all the
checkboxes after you do your letters.