I have a search form which displays the results in a subform (datasheet style). I want to be able to double click on a row in search results subform and another form load up and its data be retrieved based on the ID in the subform. But I cant figure out what to put in the VBA to get the current...