Peter,
Okay, I get it. However, the question is, when you open the form, do you
want to show all records in the table, or just those from which the user may
select?
:
Klatuu,
I think I explain it wrong. I need them to use the checkbox to select the
record. But I have to make sure they cannot select it if a condition is not
met. It's like selecting to send a message to someone who does not have an
adress.
Thanks,
Peter
:
First, create a Select query based on the table that is the recordsource for
your form. Add a field to it with a condition that will result in true or
false:
Example:
MyField: [FIELD_ONE] > [FIELD_TWO]
Then make the query the recordsource for your form and make the contorl
source for the added field a check box.
:
Thanks Rick but it's not that easy. The checkbox has to be enabled or not
depending on a source value at the opening of the form.
The collecting of the result is not a big deal.
Peter
:
You need to add a checkbox field to your table and then include it in the
form just like any other field.
To collect the checked items, just create a query that selects all records
where the new field is true.
To select all, you would need to use some type of code.
--
Rick B
I need to add a checkbox to each detail section of a continuous form. The
checkbox needs to be enabled or not depending on the value of a source
field.
I need to collect the selected checkboxes into the source data.
A "select all" button in the footer section would be a plus.
I suppose I need to build it with some VBA code?
thanks for any suggestions!
Peter