move to record when I click on field in subform

[tbac]

I have a main form and a subform. I want to move to a specific record in the Main form when I click on the field 'Name' in the subform, but when I do I get the message, "Not a valid bookmark". Here is the event that runs in the subform when you double-click on the 'Name' field:

Dim Main As Form, rst As DAO.Recordset

Set Main = Forms!CrossesPED2ChooseParents.Form

'Sync forms
Set rst = Me.RecordsetClone
rst.FindFirst "[NAME] = '" & Me![NAME] & "'"
Me.Bookmark = rst.Bookmark
Main.Bookmark = rst.Bookmark

 

[PHV]

How is the mainform's record related to the subform's NAME control ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya tbac . . .

In parallel with [blue]PHV[/blue] is the subForm synchronized with [blue]Master/Child link[/blue] properties?

Try this:

[blue]Dim frm As Form
   
   Set frm = Forms(Me.Parent.Name)
   
   frm.Recordset.FindFirst "[NAME] = '" & Me![NAME] & "'"
   
   set frm = nothing[/blue]

See Ya! . . . . . .