Retrieving data from a row in a subform datasheet

[AndrewWhitelaw]

I am developing a database to handle gift aid for a charity.

I have a donor selection form that comprises combos boxes allowing the selection of postcode, name, house number.
As the user selects data in a combo a subform show as a list of potential donors from the database, as the user selects more combos the datasheet updates presenting fewer potential donors.

As the user selects from the combos I have some VBA that runs and SQL command that clears the temporary table and dumps the selected data there and requeries the subform. The subform datasource is the temp table.

The idea was to allow the user to select a row from the datasheet but I am having trouble finding out how to retrieve the selected data in VBA.
Any ideas?

 

[AndrewWhitelaw]

Found my mistake.
I have using a table as a subform datasheet. I created a form of the table and added that as a subform.
Accessing the selected record is available through a mouseup event on the subform using me.currentrecord.
I shall go stand in the corner now for being stupid.