Web Browser Control Google API Static Maps Latitude and Longitude

[kyoch]

I have a form with a web browser control, path is to Google API static map website which marks lats and longs.

This form has a subform which has multiple lats and longs which I'd like to map in the web browser control on the main form.

Any ideas?

 

[arnelgp]

use the Current event of you subform:

dim url as string
url = "https://maps.google.com/?ll=" & [latitudeField] & "," & [longitudeField]
Me.Parent.webbrowser.object.navigate url

 

[kyoch]

Thanks for the quick response.

Run-time error 2465 "Application-defined or object-defined error" on:
Me.Parent.webbrowser.object.navigate url

 

[kyoch]

Nvm that last one got it.

Now, it's working but there's 2 things...

1. The subform is constantly refreshing and when I switch to next records, it reverts back to the first record.

2. This displays each record but not simultaneously. I didn't make that clear in the original post but I'm wondering if I can plot multiple lats and longs on the same map.

 

[kyoch]

So I deleted the subform and remade it. That solved the switching to the first record automatically but my cursor still looks like it's refreshing every second.

Still looking to be able to plot multiple records on same map on parent form.

 

[kyoch]

So while it's staying on the same record and displaying the correct lat and long on the main form, I can't select filter anything inside the subform. Anytime I try to select something in the subform it deselects itself and I can't perform any filter functions.

For some reason, the On Current event in the subform is acting funny. Any suggestions on how to simultaneously mark multiple lats and longs?