How to make an active checkbox in a report?
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.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a report that groups the results by whether the status of the record is "Active" (checkbox = true) or "Inactive" (checkbox = false). However, instead of justdisplaying the checkbox in the report as a group header, I would rather put a label there, such as "All Active Items" and "All Inactive Items", depending on whether ornot the Active checkbox is true or false.
I tried the following code in the On Load event of the form, but I don't get the correct results:
when I am in the report and I click on the checkbox, it needs to open the form on that specific record, check the box to yes or no depending what the current status is. and the close theform and refresh the report so that the checkbox shows checked or not.
I know data on a report can't be changed. but I need this to work.
I would like to generate one report that only includes records that have the checkbox checked, and the other report to only include records that do not have the checkbox checked.
I have also changed the properties of the report detail section (and the labels) to can grow/shrink as ideally I would like the report to only show the relevant, ticked checkboxes without extra space between them.
I have a table with records of all of the consumers we have worked with, with current consumers identified by a checkbox (Active). I've created queries that show either all active or all inactive based on this checkbox, so I can create separate forms to this data.
The problem is, I'm building this database for people who will break anything that isn't completely apparent,and if they have to select a different form they will (somehow) end up in a table or query and break things, or just call me and cry about it.
So. I need check boxes (or opinion bubbles) in the header (preferably) of the form that allow the user to check whether or not they want to see active consumers, inactive, or both, and havethe data in the detail section reflect either query or the master table (for both).
This is part of a larger project: w (dot) access-programmers (dot) co.php?t=231813
checkbox 2 is unchecked.
visible when the checkbox response = Yes.
I tried the OnLoad event of the form
Private Sub Report_Load()
If Checkbox = "Yes" Then
Label.Visible = True
Textbox.Visible = True
This didn't work. I am unable to define the event for the textbox and label directly because this is a report and not a form.
The same shall be sorted by Inv. No.
Now I want a report showing records for 4 checkbox mentioned above if any one of them is not checked (Ticked / Selected) as per the Inv. no.
Can you show me the method. I am a novice to Criteria & SQL Codings.