Datasheet Selected Records Property?

  • Thread starter Thread starter JP
  • Start date Start date
J

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
 
JP said:
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?
Click to expand...

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?
Click to expand...

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