Are you using VB
6.0, I am doing it in the following way.
I will include one column of width 10 and put the primary key of the record in that column. This column won't be noticed since its width is very small.
Then on double clicking, I can pass this value to a subroutine.
Childish method. But simple.