Datasheet Selected Records Property?

[JP]

I would like to use a datasheet view as a subform, but I'm having problems
in VBA finding where the list of records is stored.



Using the shift key and record selector column I can select a block of
records in a datasheet view. The problem I'm having is finding which
records are selected from VBA. How can I find the records selected relative
to the form or Me property?



Similarly, how can I find the records left in the datasheet view after
applying a filter?



TIA, JP

 

[Dirk Goldgar]

I would like to use a datasheet view as a subform, but I'm having
problems in VBA finding where the list of records is stored.



Using the shift key and record selector column I can select a block of
records in a datasheet view. The problem I'm having is finding which
records are selected from VBA. How can I find the records selected
relative to the form or Me property?

As I recall, this is available by way of the the form's SelTop and
SelHeight properties.

Similarly, how can I find the records left in the datasheet view
after applying a filter?

The form's RecordsetClone property returns a recordset containing these
records.