Filtering another form

[Crilen007]

I have a form where people can edit pager data.

Now someone wanted to search by location, so i had them select a location and it brings up a list of the people in that location. (in a new form)

Im wondering how i can have them double click a person and it will cycle to that record on the first form.


Any ideas?

ive tried variations of this

Private Sub txtEmpid_DblClick(Cancel As Integer)
    'Dim rs As Object

    'Set rs = Forms.frmPager.Recordset.Clone
    Forms.frmPager.SetFocus
    Forms.frmPager.DoCmd.ApplyFilter , "pagerId = " & Me.txtPagerID
    'rs.FindFirst "[PagerID] = " & Str(Nz(Me!txtPagerID))
      
End Sub

 

[wh00t]

try

Private Sub txtEmpid_DblClick(Cancel As Integer)

    Dim rs As Recordset

    Set rs = Forms!frmPager.RecordsetClone

    rs.FindFirst "pagerId = " & Me.txtPagerID

    Forms!frmPager.Bookmark = rs.Bookmark

End Sub

 

[Crilen007]

Perfect, thanks a million =)