Unbound checkbox in subform

[swas]

Hello,

I want to create a list of records from a table and display in a subform.
That's no worries.

Against these records I want to have a checkbox so the user can select those
records wanted, to generate some reporting requirements.

The question is, how can I do this? I am assuming continuous form view. If
the checkbox is unbound then when checked, all records check. I could bind
the checkbox to a field, but it is only for this form - I don't want to store
the value permanently. I have nothing to bind it to.

Is the only solution a temoprary table with a checkbox? Can I generate a
checkbox only for a given form, or must it be bound to a table?


Thanks in advance.


swas

 

[Arvin Meyer [MVP]]

It must be bound to a table, so you can use either a temporary table, or add
the field to your table and clear it when you close your form. That's easily
done with a simple update query.

UPDATE tblMyData SET Include = 0;

 

[Marshall Barton]

I want to create a list of records from a table and display in a subform.
That's no worries.

Against these records I want to have a checkbox so the user can select those
records wanted, to generate some reporting requirements.

The question is, how can I do this? I am assuming continuous form view. If
the checkbox is unbound then when checked, all records check. I could bind
the checkbox to a field, but it is only for this form - I don't want to store
the value permanently. I have nothing to bind it to.

Is the only solution a temoprary table with a checkbox? Can I generate a
checkbox only for a given form, or must it be bound to a table?

This looks like a good use of Albert's Mult Select code at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[swas]

Thanks for the quick replies.

Interesting to see use of a collection as a solution. I did get a few
changing results - trying to check a new record creates problems for other
records changed afterwards - though this could be easily fixed in code.

Thanks again.


swas