use a subform like a list box

[Guest]

I am trying to use a subform to navigate the parent form. Any idea how I do
that?

 

[John Vinson]

I am trying to use a subform to navigate the parent form. Any idea how I do
that?

Won't be all that easy! You'll need to use a Subform without any
Master/Child Link relationship (unusual but legitimate); and it should
be based on a Snapshot query of the table in order to avoid conflicts
("the record is already open for edit by another user..." meaning the
other form).

Something like this should work in the Click event of some textbox on
the subform:

Private Sub txtID_Click()
Dim rs As DAO.Recordset
Set rs = Parent.RecordsetClone
rs.FindFirst "[ID] = " & Me!txtID
If rs.NoMatch Then
MsgBox "Record not found"
Else
Parent.Bookmark = rs.Bookmark
End If
End Sub

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

THATS THE TICKET!!! Thanks for your help!