I'm familiar with getting VBA to select a particular record in an Access table, highlighting it as the current record.
But I'm at a loss to do the reverse: if the user manually selects (highlights) a record in an open Access table, how does the VBA program detect which record has been highlighted? Might there be a way, say, to use the indicated record number at the lower navigation bar that contains pointers to the next record, last record, etc.?
Any such help would be appreciated!
But I'm at a loss to do the reverse: if the user manually selects (highlights) a record in an open Access table, how does the VBA program detect which record has been highlighted? Might there be a way, say, to use the indicated record number at the lower navigation bar that contains pointers to the next record, last record, etc.?
Any such help would be appreciated!