With ActiveX Connector, you can use DoZoomToFeatures function of Map object to zoom to the features you are interested in. However, this function also limits the Recordset of the active layer to only those records that satisfy the criteria specified in the function.
For example, the code:
Code:Map.DoZoomToFeatures statelayer,"STATE_NAME","'Oregon','California'"will make the map zoom to the area that contains Oregon and California. It also results in the recordset: statelayer.Recordset to contain just 2 records, 1 for Oregon and California each.
The WHERE expression passed to the DoZoomToFeatures function acts as a filter for the given Layer. Hence, only those features which satisfy the expression will be included in the Recordset.
statelayer.Recordset.Filter.WhereExpression = ""
Get help from ArcGIS experts
Download the Esri Support App