record selected in SUbform data to be displayed on main form

[mrbabji]

Hi everybody

Request you all to help me out in resolving the following issue.

I have a Main form and a sub form. Subform has got certain data. I need to display the data on the main form of the record selected in the sub form.



Please help

[pbaldy]

This type of thing:

Private Sub ID_DblClick(Cancel As Integer)
  Dim rs                      As Object

  Set rs = Forms.FindMainRecordBasedonSubformRecord.RecordsetClone
  rs.FindFirst "[ID] = " & Me.ID

  Forms!FindMainRecordBasedonSubformRecord.Bookmark = rs.Bookmark

  Set rs = Nothing
End Sub