Checkbox select to print report

[g28dman]

I am having trouble wraping my head around this am am seeking help (I have done a search and have made select box print labels and get the general idea) But this is a different format.

I have 3 tables running through a query supplying info for the report. The report is filtered using a date range and a combobox. When the report is ran, I have a an update query that goes back and tells my detailtable which ones have been printed.

For reasons to long to explain....I need to transform my query for reporting to form view showing continuous records. On this I need to add a yes/no check box to select the records that need to be printed. Then a combo box for my final filter.

I think I am making this more complicated than needs to be, but when I set my new form with the query containing yes/no box criteria set to yes I have no records showing up...I am so confused

 

[g28dman]

Solution for those looking...

Problem : I needed to keep track of what has/has not been printed. I had a Printed field in my table and used an update query to make this work. The user however wanted the choice of which records to print - instead of being locked into a date mode, which I had done.

What I done was add another field to my record set [ToPrint].

I made a query that included my original data and added the [ToPrint] field. The criteria for this query was Printed=0 and ToPrint=0. I hooked this query to a continous form, where I could check the ToPrint field. Once checked this made the Printed field = 1.

So now I need a query that my report is based on ToPrint = 1, This is what my report is based on.

My print button does more than print, it requeries the form to meet only the criteria, it runs an update query to change the ToPrint field back to 0, so it's not included on my original query that the form is based on.

I hope this makes sense....I hope that I help someone else down the road.