Populating a checkbox

[Access_Newbie_2]

Hi..

I have a continous form that displays the results of a search prior to printing them.. I have a "TmepPrint" flag on this form that controls a temp field on my table to filter records to include in that report... What I would like to do is either on the OpenEvent of the form or on a cmd button have all the records on my forms checkbox set to true... Since its actually controlling a record i cant just do default value = true... Thanks for help!

 

[WayneRyan]

Access,

You can make an update query to set/clear the flag in all records
prior to running the form.

Wayne

 

[Access_Newbie_2]

No...

My dB has say 10,568 Records....

I search it based on multiple criteria... and get say 48 results..

Now I want to print a report to include ONLY these results..

So I have a "TempPrint" field on my table... I need to know how to set that field to TRUE for my results ONLY so when my report opens (which is based on a query TempPrint = true) only the results of my search will be printed on my report... Then I already have a update query that clears the flag on main table which runs after the report is made...


Hope this is more clear...

 

[WayneRyan]

Access,

The query that returns the 48 items, can be an update query and
update the 48 items.

Or, the query that returns the 48 items can feed the report
and you need no checkbox.

Wayne

 

[Access_Newbie_2]

Oh well the items arent selected via a query....

Its a Dynamic SQL statement builder (QBF).....

 

[Access_Newbie_2]

Anyway i can email u a zipped copy of my db and u can have a look??


Its too big for this forumn (i think.... 500kB)

 

[WayneRyan]

Access,

You can still use the DoCmd.RunSQL to run an update
command. You have all of the components for the Where
clause.

Wayne