Find record on parent form

[dee]

I have a parent form called "FmLeads". It contains a numeric field
called "ID"
It also contains a 3 tab 'Tab Control'.

Each tab contains a subform. One of the subforms
"FmSalesDispositionAll" is a 'continuous forms' design, on which each
record contains a numeric field called "ID".

I need code for a 'On Dbl Cick' Event Procedure on the subform's
("FmSalesDispositionAll") ID field.
I want the user to be able to double click on one of the ID numbers,
which would then find and go to the matching record of the parent form
"FmLeads". This record always exists.

I'm a new to this and would really appreciate if someone could give me
the subroutine code.

 

[Marshall Barton]

I have a parent form called "FmLeads". It contains a numeric field
called "ID"
It also contains a 3 tab 'Tab Control'.

Each tab contains a subform. One of the subforms
"FmSalesDispositionAll" is a 'continuous forms' design, on which each
record contains a numeric field called "ID".

I need code for a 'On Dbl Cick' Event Procedure on the subform's
("FmSalesDispositionAll") ID field.
I want the user to be able to double click on one of the ID numbers,
which would then find and go to the matching record of the parent form
"FmLeads". This record always exists.

Try this kind of thing:

If Me.Dirty Then Me.Dirty = False 'save if needed
With Parent.RecordsetClone
.FindFirst "ID = " & Me.ID
If Not .NoMatch Then
Parent.Bookmark = .Bookmark
End If
End With

 

[dee]

Try this kind of thing:

If Me.Dirty Then Me.Dirty = False 'save if needed
With Parent.RecordsetClone
.FindFirst "ID = " & Me.ID
If Not .NoMatch Then
Parent.Bookmark = .Bookmark
End If
End With

Thank you very much. Works great