Looping help with report

[tssparky]

I have a report with a field called "status"
The report only shows items with a status of "open"

I want to be able to loop through the line items and change the status's to "closed" with a button click.

I can do this with a form if needed.

Thanks for your help.

 

[Ranman256]

don't 'loop thru' , DO run an update query,
change status to closed.

docmd.openquery "quSetStatusClosed"

 

[theDBguy]

Hi. Just to clarify your request, you want all records in your table to have a status of closed, correct? Do you only have two statuses: open and closed? Or are there other status as well?