Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


unbound checkbox on a continuous Form

Posted on 2004-10-23
Medium Priority
Last Modified: 2007-12-19
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 ?
Question by:smayshar
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 12

Expert Comment

by:Bob Lamberson
ID: 12391012
Check1 = vbChecked
Check2 = vbChecked


Accepted Solution

Ctrl-R earned 252 total points
ID: 12391138
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.
LVL 11

Assisted Solution

Jokra_the_Barbarian earned 248 total points
ID: 12391493
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.

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question