MapForums

Hello,

I've got a map with linked datas.

I've to goto a pushpin of a customer (not unique code) witch owns 2 computers (unique code).

Datas aren't the sames so, I created a source for computers A
and another source for computers B

When I click on a pushpin, I've got a dialog box to choose
between 2 locations.

When I display the name of the pushpins, I show the name of the
customer. Into the Ballon, I see the computer number.

So, how to arange the FindPushpin method to go to the good
pushpin ?

I don't know if I'm clear enough so if you need more explainations, ask to me !

Regards,

Vincent BENNER

The FindPushpin Method searches on the Pushpin Name. This sample code will let you search by name and note.

Set objmap = MappointControl1.ActiveMap

For Each objDataset In objmap.DataSets
Set objRecordset = objDataset.QueryAllRecords

Do Until objRecordset.EOF

If InStr(objRecordset.Pushpin.Name, "CompanyName") Then
If InStr(objRecordset.Pushpin.Note, "ComputerNumber") Then
MsgBox "Found It"
End If
End If

objRecordset.MoveNext
Loop
Next

__________________
John
http://www.support-pc.com

Order MapPoint 2006 Here
https://secure.mp2kmag.com/?refer=support-PC

OK, it works !

Thank you very much.

Vincent BENNER