A lot of room for interpretation wrt your questions, I think.
Is there a way to identify the first visible Subform record?
ID how?
I would also be able to calculate the last visible record
Calculate a record?? What does that mean? Does any of that have to do with you selecting a record and looking at the built in record navigation controls, which tell you that record is #x out of #n?
So I requery the subform. Of course this makes the subform start again at the top.
Research how to clone the form recordset, set a bookmark to the current record, then after requerying, make the bookmarked record the current record.
I would like to know the value of the first visible record
Records don't have values - fields have values.
I'd be satisfied with finding the bookmark or record number of the first visible record
Click on a field in the record or use the record selectors if you show them.
the recordset may be in one order, and the Subform may have it's OrderBy set, so it's displaying in a different order.
That makes no sense to me. A form recordset has an order. It is either ascending (by default or by choice), or descending by choice. AFAIK, a recordset cannot have one order while a form has another order.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.