I am a n00b with VBA and need some help. I have a form that lists data about hundreds of employees. in that form is an address column that is also in a residences table. I put links to google maps for each address in the residence table. I am trying to develop a button that on click will go into the residence table and return the link that is attached to the address of the employee on the form and then open that link.
here is what i have so far but i keep getting a 490 error:
Private Sub LookUpMap_Click()
Dim ds As DAO.Database
Dim rs As DAO.Recordset
Dim strMap As String
strMap = "(Select Google_Map From Residences Where Me.Permanent_Address = Address)"
Application.FollowHyperlink strMap, , True, True
End Sub
any help is appreciated
here is what i have so far but i keep getting a 490 error:
Private Sub LookUpMap_Click()
Dim ds As DAO.Database
Dim rs As DAO.Recordset
Dim strMap As String
strMap = "(Select Google_Map From Residences Where Me.Permanent_Address = Address)"
Application.FollowHyperlink strMap, , True, True
End Sub
any help is appreciated