trying to access records in a report from vba..

[Toeying]

I have created a report based on a query. I now want to access the records selected by the query i.e the records that show up in the report and update the printed field from no to yes. how do I do it. My thinking is to use a while (!EOF) Do... Statement. But being a vb newbie I dont know how to access the read the records in the report.
Thanks for your help

 

[namliam]

I would run an update query to set it.

 

[vbaInet]

Via the RECORD SOURCE property of the report, create an UPDATE query.

 

[Toeying]

The record source property opens the query builder window. where do u put the update query? Thanks