I need to know if it is possible to reference the selected row in a datasheet through VBA code and get the value of the a field in the selected row. In order to use a command button to open that specific record for editing and also to delete that specific record. Any ideas, I am out of them!

Thank you.

The easiest method is to put a button on the subform that opens a form that displays all the data for the selected record.