Snip...
>
>Whew...I think I need to see this one in action. I can't quite picture how this works. I hate to ask, but do you have an example?
>
>Sylvia
Hi Sylvia,
The real form needs so many translations, instead I would give an example :

* A preselection Grid is used for sea and land resources
* In practicity it's vital to keep sea and land resources separated
* Data is highly different
* Grid is something like :
Latitude,Longitude,Location type,Height/Depth,Chemical
36.2553N, 26.7832E, Sea, 70, oPO4
37.1253N, 30.1345E, Land, 150, Fe++

* Now here Lat/Long data is in one table
* User cannot change Location (preknown)
* Measurements done there are classified with height or depth
* User also cannot change height/depth and chemical but choose from combos
* 4 combos are like :
* 1- cmbHeights
select height from landlocs ;
*       where latitude=locs.latitude ;
*        and longitude = locs.longitude ;
*        into cursor hgtList
* 2- cmbDepths
* select height from sealocs ;
*       where latitude=locs.latitude ;
*        and longitude = locs.longitude ;
*        into cursor depthList
* 3- cmbSeaChemicals
* select chemname from sealocs ;
*       where latitude=locs.latitude ;
*        and longitude = locs.longitude ;
*        and dMeasured = thisform.dChems ;
*        and depth = this.parent.parent.HgtDpthCol.cmbDepths.value ;
*        into cursor chemlist1
* 4- cmbLandChemicals
* select chemname from landlocs ;
*       where latitude=locs.latitude ;
*        and longitude = locs.longitude ;
*        and dMeasured = thisform.dChems ;
*        and height = this.parent.parent.HgtDpthCol.cmbHeights.value ;
*        into cursor chemlist2
* 1 and 2 are in column HgtDpthCol, 3 and 4 are in ChemsCol column.
* Where needed, columns requery is called.
* ...HgtDpthCol.Dynamiccurrentcontrol = ;
*     iif(locs.loctype = "Sea","cmbDepths","cmbHeights")
* ...ChemsCol.Dynamiccurrentcontrol = ;
*     iif(locs.loctype = "Sea","cmbSeaChemicals","cmbLandChemicals")

Cetin