Maybe I am not doing a good job of explaining what I need to do. I was tasked with creating an interactive checklist that will give the user a list based on certain criteria. I have placed the criteria on a form that user then uses to select thier criteria. They click a button that will run a query, which gives the information they need out of the table, and it is presented to them in the form of a report. Then the user has to go through each line item that was returned on the report and decide to use it or not, based on thier judegment. We would like them to be able to check a checkbox to say what they did, so they can turn it in with the project.

Having all the criteria all on one checklist will defeat the purpose of doing the query, which refines the data to only ones that will apply to the user's circumstance.

Also, using the report keeps the user from somehow altering the database. Thank you for helping by the way. I have been stuck on this for some time now, trying to find a fix.

Again, I would say use a form to do what you want after the query has run and the user is presented with the list of choices.Present them with a FORM instead and then finalize the Report based on what they have entered instead of trying to edit a Read Only Report. So you have a user form that runs a query and then USE another FORM to enter the final end result. I have no other suggestions to you other that this. Hope it helps.

Okay, if I do it in a form is there a way to display the info in a manner where the user cannot change it?

Yes, just make the fields either Visible/Invisible or Enabled or Not enabled.
Me.yourfiledname.Enabled = False makes it not editable.
Me.yourfieldname.Visible = False makes it invisible

Use code to set your criteria. If this or that, then whatever!

Thanks Burrina. I added a form that would allow the user to edit the check box field and then a button opens to report then another button to export to pdf. I feel like this adds extra steps, but is still pretty user friendly and got the job done. I will see what the boss thinks. Thank you for your help.

in the reports detail on format evenbt set the approipriate code


eg:-

if mycolumn1 = something then mycheckbox1 = true else mycheckbox1 = false
if mycolumn2 = something then mycheckbox2 = true else mycheckbox2 = false

to set this code open the report in design mode
select the detail section of the report
select properties (F4)
click the tab that has 'build events' in it (think it may be other properties
then build code

lets say one of your columns is called IsProjectFinished and the relevant checkbox is called ckbProjFinished
then
if IsProjectFinished = true then ckbProjFinished = true else ckbProjFinished = false

mind you if the columns in the table are boolean you cna assign the value directly
eg
ckbProjFinished.value = IsProjectFinished

bear in mind you can also use the NOT operator to set the other value
ckbProjFinished.value = NOT (IsProjectFinished)
ie whatever value IsProjectFinished is set it to the opposite

Healdem,

I want the value to be dependent on the users input, not a table value.

Your Very Welcome.