Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    64

    Unanswered: How to make an active checkbox in a report?

    I have a form that runs a query that automatically opens a report. My report includes a checkbox field that correlates to each entry. I want the checkbox to be active in the report. Is there a way to do this?

    I want to be able to double check the document attached to every entry and then check the box when it has been checked. However, I want the checkbox to be usable on the report so the user doesn't have to go into the table to check it. Right now, the checkbox is only an image and isn't interactive on the report.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Forms are designed for entering/editing data, Reports are designed to display/print data, and never the twain should meet! Controls are only 'interactive,' in this sense, in Tables, Forms or Queries.

    And end users should never be allowed to 'go into the table!' Users should only enter/change data through Forms or Queries!

    Your review needs to take place in a Form or Query and then print your Report.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    May 2012
    Posts
    64
    Is there another way to do what I want to do? I understand that I could just have my form run my query and then check the box from the query, but there is no way to make a query look like a report (more readable and easier to navigate).

    How would I go about making a form appear for each entry in the query? Like you hit run query from the form and it opens another form that has the entry where you can check the box, and then you hit the next button for the next entry?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •