I am trying to add a button my my Access form that takes an address from form fields and brings up a Google map of that address. I have been searching online and only find references that are many years old. Below is what I am trying but it doesn't bring up the address. Only google Maps for my current location.
any help would be greatly appreciated. - Thank You
Dim straddress As String
Dim strlink As String
Dim strstate As String
On Error GoTo myErr
strstate = "New York"
straddress = Forms![selected properties1].address & "+" & Forms![selected properties1].borough & "+" & strstate & "+" & Forms![selected properties1].Zip
strlink = "http://maps.google.com/maps?q=
" & straddress
On Error GoTo 0