Checkbox on continuous forms

[Guest]

I've been away from Access for a long time and hope that I haven't overlooked something basic. I am using Access 2002 and I want to add a checkbox to forms outputting search (by name, by email address, by relationship to an organization, etc) results. Users could check the control in order to select those records to whom an email would be sent. It make sense for these results to be displayed in continuous forms but I don't know how to deal with Access's inability to use unbound controls on continuous forms. These form have many other uses, so for user ease I would like to have the email_to selection operate directly from these same forms.

So what approaches would allow me to have users select rows?

Thanks

Neil Berkowitz

 

[Wayne Morgan]

You would need to make the checkbox a bound control by adding a field for it
to the table. After sending the email, use an Update Query to change all of
that field's values back to False so that the boxes can be checked next
time. This will also give you an easy way to filter which records to send,
it will be the ones where this field is True.

--
Wayne Morgan
MS Access MVP

I've been away from Access for a long time and hope that I haven't

overlooked something basic. I am using Access 2002 and I want to add a
checkbox to forms outputting search (by name, by email address, by
relationship to an organization, etc) results. Users could check the
control in order to select those records to whom an email would be sent. It
make sense for these results to be displayed in continuous forms but I don't
know how to deal with Access's inability to use unbound controls on
continuous forms. These form have many other uses, so for user ease I would
like to have the email_to selection operate directly from these same forms.

 

[Albert D. Kallal]

You have several choices.

1) You could add a check box field to each record..and then bind the check
box for the continues form (this likely is NOT a good idea if your system is
going to be multi user).

2) Bind the control to a function that retunes true, or false.

Simply have the function check the current checked list against a
collection. (you use the after update event of the check box to either add,
or remove the record id from the collection. I have not tired this..but in
principal it should work fine.

If the list is small, then again you could use a listbox..as that does allow
multi-select...