Looping help with report (1 Viewer)

T

tssparky

Registered User.

Local time

Today, 01:32

Joined

May 24, 2017

Messages

23

• May 15, 2019

• #1

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

Well-known member

Local time

Today, 04:32

Joined

Apr 9, 2015

Messages

4,339

• May 15, 2019

• #2

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

docmd.openquery "quSetStatusClosed"

 

theDBguy

I’m here to help

Staff member

Local time

Today, 01:32

Joined

Oct 29, 2018

Messages

21,449

• May 15, 2019

• #3

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?