prestwrlfc

Hi.

I've created a database in Microsoft Access. In one of my forms I've created a button, which when clicked, opens IE and loads up Google.

However, my database is made for a rentals company. In the form is a Postcode/ZIP Code field. I want to create a button so that when it's clicked it opens up IE and loads multimap and automatically adds the postcode in for each record.

http://www.multimap.com/maps/?hloc=GB|'POSTCODE HERE'

eg: http://www.multimap.com/maps/?hloc=GB|N207UJ


This is the code I have upto now but I need and ID to enter in the URL which will represent each record's postcode.

Private Sub Command0_Click()
Dim strUrl As String
strUrl = "http://www.google.com"
Call Shell("explorer.exe " & strUrl, vbMaximizedFocus)
End Sub

Thanks in advance.