Unbound Check Box Error

E

Edgar Thoemmes

I am using a form to display the contents of a query, what I would like to do
is have some kind of option to select certain records (I was thinking about a
check box) and then I could create a new recordset with only the selected
records in it.

The query contains a field for an email address and what I would like to do
is open the form, select which records I would like to email and then click a
cmd button and send each record via email to the address in the email field.
I have got some code for the actual email procedure but I cannot seem to
create the check box (When I try this the check box is either checked for all
records or unchecked)

Can anyone help me with this?
 
S

SteveS

It sounds like you are trying to use an unbound check box on a continous
form. The problem is that if you have 30 records, the unbound check box is
displayed 30 times - but it is the *same* check box - not 30 check boxes!

To fix this, add a field to your table (maybe names - chkSelectMail) of type
Yes/No.

Add this field to your query and bind the check box control to the chk
field. When you check the box, it is for a specific record. Now if there are
30 records, there are 30 check boxes.....

Steve
 
Top