Hi -
is there a way to launch MapPoint to goto a specific address from a command button on a form in Microsoft Access?
any help appreciated

cd

I do this by creating a form with mappoint as an activeX control named "mymap"

the form has a field for address, city, state, and zip

Next add this to the onload property of the form

Me.mymap.NewMap geoMapNorthAmerica
mymap.Toolbars.Item("Navigation").Visible = True
'Show School
Me.mymap.ActiveMap.PlaceCategories("Schools").Visi ble = True

Dim oMap As MapPoint.map
Set oMap = GetObject(, "mappoint.application").ActiveMap
Dim lochome As MapPoint.Location
Set lochome = oMap.FindAddressResults(, Me!city, , Me!state, Me!Zip, "USA")(1)

lochome.Goto


Hope this will be helpful
Randye

Worked great!