HI, I'm new to VBA programming and am trying to see if there is a way to click on a record in a subform and have it retrieve it into the main form.

example is i have a main form and a subform built of a reworkno field. I want to be able to click on that record in the subform and have have pull it into the current form.

I really appreciate any and all help i can get on this.

Thanks Clayton

Just for clarification, your example is something like a work order containing a field that references the record of the work order documenting any additional work done?

Yes that it. I actually figured it out using the following code

Private Sub Doneby_Click()
With Me.Parent.RecordsetClone
      'Assuming the search value is a string
    .FindFirst "[Doneby] = '" & Me![Doneby] & "'"
      If Not .NoMatch Then
        Me.Parent.Bookmark = .Bookmark
    End If
End With

End Sub


Clayton

Note that you seem to have your form/subform relationship BACKWARDS.

Typically, one selects something from the MAIN form and the SUBFORM updates, not the other way around. If you do it right, the main and subforms will have parent/child link fields properties that automatically reset the subform once the main form goes from one record to the next.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division