Forms

[bgcogen]

Hi.
Ok, this is what I have to do. My company has different locations with certain information associated with each site (like address, engines, safety record etc).

All the information for all the sites are storded in the same table. Grand. But I have a map with buttons for each site on the map. I want to set it up in such a way so that if someone clicks on say, Dublin, all the information relating to record "Dublin" in my table is displayed in either a form or a report.

How do I do this???

Thanks for any suggestions,
Declan

 

[Memnoch1207]

You have your map w/ the buttons. Then you have your (lets say 3) reports. the reports are already created. Your buttons on your map should have some code to get them to open teh specified report. Lets do Dublin.
The button you hit to show the dublin report should have this code under it to view the dublin report.

Private Sub cmdDublin(On_Click)'Click the Dublin Button
if rptDublin.Visible = False Then
rptDublin.Show
End Sub

this is all you need to have to show the Dublin report.

[This message has been edited by Memnoch1207 (edited 05-14-2002).]

 

[Pat Hartman]

You don't need a separate form/report for each place on the map. Use the OpenReport or OpenForm method with the wherecriteria argument and supply the key of the record you want to show.