VBA Looping

[JFHBIFF]

Hello,

Is it possible to run a loop through each record in query, but refresh the query in between loops?

The query I am looping needs to be updated before moving to the next record.

Thanks for any help. I have found plenty of advice on how to run through each record, but can't figure out how to get the query to refresh before looping.

Thanks,
John

 

[gemma-the-husky]

it sounds strange.

can you explain why you need to requery after each iteration

 

[Galaxiom]

Sounds like an unusual requirement. How does the processing of one record affect the subsequent records in the query?

If you use a dynamic recordset the changes made by the processing should be reflected throughout the recordset. Unless you using an aggregate query that would prevent it being updated.