Doubleclick, select record and insert into another form

[jimatparks]

Hi,
I am new, not brand new, but new to VBA. I am trying to get the double-click to select the record the user d-clicks on and move the single record to a new form.
The record appears in a subform as part of a query selection. Can anyone help with this? Thanks, Jim

[debasisdas]

Question moved to Visual Basic Forum from VB Articles Section.