Double click field in Subform

[Glenn Suggs]

I'm trying to get my code to recognize the value of a "double-clicked" field
in a subform that displays all details matching certain criteria. The
double-click event fires ok but the return value is always the one from the
first detail row, not the one in the row that was chosen.

Does anyone know of a fix for this or why it might be happening?

Thanks in advance

 

[PC Datasheet]

Please post your doubleclick code.