export selected rows on continuous form

[nycdon]

I have a continuous form which returns rows from search filters. I'd like to
add a checkbox to each resultant row, then whichever is checked - to export
those selected to excel.
What I cant figure is how to manage finding which row(s) on form have been
checked..?
thanks!

 

[John W. Vinson]

I have a continuous form which returns rows from search filters. I'd like to
add a checkbox to each resultant row, then whichever is checked - to export
those selected to excel.
What I cant figure is how to manage finding which row(s) on form have been
checked..?
thanks!

You'll need to add a Yes/No field to the table (or one of the tables)
underlying the form. A checkbox on a form isn't stored anywhere - data is
stored only in tables, not on forms or in queries.

 

[nycdon]

Thanks John - hmm, so I'd have to store it..even though just pertains to
that 1 operation?

(something like - filter form, then choose which to set Y - then export
those via query..then reset all back to N?)

 

[John W. Vinson]

Thanks John - hmm, so I'd have to store it..even though just pertains to
that 1 operation?

(something like - filter form, then choose which to set Y - then export
those via query..then reset all back to N?)

You have an arbitrary number of records. Some records must be True (-1); some
other records must be False.

The Form cannot contain or store record specific data. You must store it
either in your main table or in a second table related to the first one.

 

[Albert D. Kallal]

Thanks John - hmm, so I'd have to store it..even though just pertains to
that 1 operation?

In general, yes.

However...

I have a sample download that uses a check box column that is NOT bound to a
field,
but populates the check box into a collection. I bind the check box to a
function...

You can find it here:
Multi Select Example.
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

So, this example shows how to use a checkbox on a continues form that is NOT
bound to a table.