unbound checkbox on a continuous Form

On a continuous Form, I put an unbound checkbox, and in the form footer I have a buttom that should print all the ticked records.
How can I tick an individualy box, with out having them all ticked ?
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Ctrl-RConnect With a Mentor Commented:
I just ran into that problem myself.

My workaround was to create a new field in the table the data was coming from that was a Yes/No field.  Then on my form I linked to that field and made it so that when the button in the footer is pressed, a macro opens a report that uses a query which only displays the records that are checked.  There is then a button to clear all selected, and it also clears all selected when the form is unloaded.

Hope that will work for you.
Bob LambersonSoftware EngineerCommented:
Check1 = vbChecked
Check2 = vbChecked

Jokra_the_BarbarianConnect With a Mentor Commented:
This link might give you some ideas. Download the database and take a look at the form and code: http://www.mvps.org/access/forms/frm0047.htm

You should be able to solve your problem using a similar technique, a combination of a record number function that uses a recordset clone, and the SelTop function.
All Courses

From novice to tech pro — start learning today.