Solved

unbound checkbox on a continuous Form

Posted on 2004-10-23
939 Views
Last Modified: 2007-12-19
Hello,
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 ?
thanks
0
Question by:smayshar
    3 Comments
     
    LVL 12

    Expert Comment

    by:BobLamberson
    Check1 = vbChecked
    Check2 = vbChecked
    etc

    Bob
    0
     

    Accepted Solution

    by:
    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.
    0
     
    LVL 11

    Assisted Solution

    by:Jokra_the_Barbarian
    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.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT Security CISA, CISSP & CISM Certification

    Master the advanced techniques required to protect network resources from external threats with the IT Cyber Security bundle. Built around industry best-practice guidelines, the IT Cyber Security bundle consists of three in-depth courses.

    In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    884 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now