P
pete
Hi
I have a list box on my main form which shows all entries in the database. I
am really struggling now, this is what I have so far and it works.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[AssetNos] = '" & Me![List80] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
What I want to do is when I click a particular record the record shows in
the relevant fields on the form ready for editing. My find next record button
just goes down the list, not very practicle when I can run up over a thousand
records a month.
Thanks
Pete
I have a list box on my main form which shows all entries in the database. I
am really struggling now, this is what I have so far and it works.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[AssetNos] = '" & Me![List80] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
What I want to do is when I click a particular record the record shows in
the relevant fields on the form ready for editing. My find next record button
just goes down the list, not very practicle when I can run up over a thousand
records a month.
Thanks
Pete