Go to record

[ddrew]

OK my forms coming along niceley. But now i have a new problem. I need to be able to click on a name in a list box and for the details of that person to be displayed in the relevent boxes on the form. I have this piece of code from an old database, that i acquired. But I dont know what it all means. I tried applying it, but there are obviousley things different. Can anybody help?

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Club Number] = " & Str(Nz(Me![List167], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

 

[ddrew]

List Box

Thought id add that the source code for the list box ithat I amusing is

SELECT[Seniors].[Name] FROM Seniors;

This is a querry