Display individual entry of subform in a new form

[thargoz via AccessMonster.com]

Hi,

I have used a query to extract a selected portion of data based on a search
criteria. From the resulting list, which is displayed in a subform, I wish to
be able to double click on a selected entry and display it in a new form to
give a more detailed view of the entry.
I have tried to code Form_OnDblClick(), but once the subform is updated, the
double click function doesn't work. The coding does however work before the
subform is populated.

Can someone help me please
Thanks
Garth

 

[June7]

Post your code for the OnDblClick event for analysis.

 

[thargoz via AccessMonster.com]

I haven't yet tried to code the populating of the textboxes on the form yet,
but this code doesn't allow the form to load once the subform is populated.
Any help populating the textboxes on the form would also be greatly
appreciated.

Thanks
Garth

Private Sub Form_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "UpdateProfessionalResponse"
DoCmd.OpenForm stDocName, acNormal, , , , , stLinkCriteria


End Sub

Post your code for the OnDblClick event for analysis.

Hi,

[quoted text clipped - 9 lines]

Thanks
Garth