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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bob LambersonSoftware EngineerCommented:
Check1 = vbChecked
Check2 = vbChecked

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.