Unbound Check Box Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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