Query loop VBA

[Arrowx7]

Hello,
What would a loop for VBA access look like if I wanted to loop elements (rows) in a query.

Thanks in advance.

 

[PHV]

Ask the VBA help engine for Recordset

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Arrowx7]

I looked at it and it's very confusing.
I have a query and I want to loop over items in the query. The VBA help engine doesn't really help, just gives me a whole bunch of parameters. But I don't undestand how to get it to loop through the query results.