Add checkbox to every record of a continuous form

[Guest]

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

 

[Rick B]

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.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

No, I surely want to display all. The operator has to see the some are not
selectable. For that reason I want to show all records but some with
checkboxes that are not enabled.

Thanks,

Peter

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

 

[Guest]

Okay, I think what you will need will be a formula to determine whether the
condition is met and put it in the Current event.

Me.MyCheckbox.Enabled = IIf(Condition, True, False)

No, I surely want to display all. The operator has to see the some are not
selectable. For that reason I want to show all records but some with
checkboxes that are not enabled.

Thanks,

Peter

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

 

[Guest]

Thanks Klatuu, I wasn't aware of the Current event.

Peter

Okay, I think what you will need will be a formula to determine whether the
condition is met and put it in the Current event.

Me.MyCheckbox.Enabled = IIf(Condition, True, False)

No, I surely want to display all. The operator has to see the some are not
selectable. For that reason I want to show all records but some with
checkboxes that are not enabled.

Thanks,

Peter

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