Recordset Data

[DMT Dave]

absolutely bang on WGM, the 3 listed in the immediate window is the last one in that list, do debug.Print is telling us that the rs is returning the correct records

Just need to get them after the loop in the shell command



Do i need to move last then move first step in the loop ? then how do i get the selected to shell command after loop ?

[Welshgasman]

No, look at Gicu's code and compare to yours where you set rsPC and see if you can not only spot the difference, but understand the difference.
You do not appear to understand the logic of the loop.
If you put debug.print rspc after setting it in the loop, that might give you a clue.

[moke123]

I am aware that because i have got my Shell command within the loop that it will open 6 x URL's

Seems a bit much to opening so many maps.
Have you looked at the Google Map Api's? https://mapsplatform.google.com/maps-products/

Also Colin's Uk Postcode db. http://www.mendipdatasystems.co.uk/u...594365454.html
even though it's UK based, you can see his mapping code.