How to plot entire column's data not just first record.

[excyclist]

I have to following code which works well for the first record in subform "By_Date_To_Award_Form" column "meetloc".

strSearch = Me!By_Date_To_Award_Form.Form.meetloc
Application.FollowHyperlink "http://maps.google.com/maps?f=q&hl=en&geocode=&q=" & strSearch & "&ie=UTF8&z=16&iwloc=addr"

How do I get it to plot all the records in the column "meetloc"? There may be up to 10 records.

[June7]

You want to build a graph of data in field meetloc? What does the hyperlink code have to do with that? What is the RowSource of the graph? Is graph in form or report? In what section? Do you want to provide project for analysis?

[excyclist]

The hyper link is to google maps, "meetloc" is a column in subform "By_Date_To_Award_Form". It contains addresses I want to show or "plot" on google maps. The code currently opens http://maps.google.com and maps the first record in the column. I would like it to map all records.

[June7]

Oh, mapping not graphing. I suspect you will have to export to xml file and then open the xml in Google Earth or your Google Maps project.