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
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
This type of thing:
Code: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