I have a Listbox on form1 and I would like it to Open form2 to the record clicked on in the listbox. Here is the code which I got to work when I crreated the listbox on Form2:
Private Sub List618_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[number] = " & Str(Nz(Me![List618], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
How can I get this to work from another Form? In other words, how can I get this Listbox to select the record which is clicked and open another form?
Thanks!
Private Sub List618_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[number] = " & Str(Nz(Me![List618], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
How can I get this to work from another Form? In other words, how can I get this Listbox to select the record which is clicked and open another form?
Thanks!