subform checkbox

  • Thread starter Thread starter bryan
  • Start date Start date
B

bryan

i have a query based subform listing e-mail adresses of
people filtered by a combobox from a main form.

I want to add a checkbox to the subform, so that the user
will select the list of e-mail adresses by checking the
desired checkboxes and send a mail to checked mail
adresses. For that part i am planning to loop through
subform's recordset and if the record's checkbox is
thicked add it to the receipents.

Problem is i don't have a checkbox field, because i don't
want to keep track of these records and when i add a
checkbox to the subform, when you check one all becomes
checked.

I wonder if there is a way of adding these checkboxes
without adding it to a table field.

Thanks for the help.
 
I wonder if there is a way of adding these checkboxes
without adding it to a table field.
Click to expand...

No.

A Continuous Form appears to have multiple rows of controls but it
really doesn't: it has ONE row of controls, displayed repeatedly. An
unbound control in a continuous form is *only one control* and can
contain only one value.

You'll need to either add a yes/no field to the table (it only takes
up three bytes with the field overhead, so it's cheap), or create a
second table with two fields - the Primary Key of your table and a
yes/no field. Base your subform on a Query with a left outer join
between your table and this table; checking the checkbox will create a
record in the second table, with the ID. You can then use the table in
a query for the report.
 
Back
Top