Well I finally figured it out with 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
Clay
--- In AccessDevelopers@yahoogroups.com, "brazilianbound"
<[EMAIL PROTECTED]> wrote:
>
> Hi all!
>
> I have a subform that populates of a field in the main form. Is
there
> a way to click on the record in the subform and have it come up in
the
> current form?
>
> Thanks - Clay
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
