Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Listbox Record Selection

Status
Not open for further replies.

number2

Technical User
Oct 25, 2001
284
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top