Databinding

[JanTore]

Hi,
I'm trying to load a dataform from another form using "hotspots" on an image. The question is how can i bind the hot spots to a database record?

The picture is a map over a country and the hotspots are cities, and by clicking on a city it loads the dataform which has information on that city. The dataform is using ADO to connect to a Access database.

Any ideas? I'm lost..

Jan Tore

 

[zemp]

If you are using a bound control then you will need a query or stored procedure for each city that you want the user to be able to click or one that you can pass a parameter to.


Then...
1.In the images click event place a selection structure that will identify which city was clicked.
2.For each case change the datasource property to the correct query or stored procedure or pass the correct parameter to your query.
3.Refresh your bound control.

If you are not using a bound control then follow the same logic. You will just have to do a bit more coding. Thanks and Good Luck!

zemp