
Displaying multiple records
I have found a record from a Access Table and can put it in a Text Box.
BUT, I want to put the following records after it in the same box (say
five). I hoping as the scroll bar is moved downward, more records will
be revealed and as it is moved upward the records before it will be
shown (it should be possible to go to the first record or last). I want
to do what the data control does. Can someone help?
Data1.Recordset.FindFirst "Address = '" & LookBox.Text & "'"
If Data1.Recordset.NoMatch Then
MsgBox "No matching records found"
LookBox.SetFocus
End If
Verse.Text = Verse
'address is the one I want to display the multiple records
Address.Text = Address
'I've tried concatenating but I don't think that's a good way to solve
'the problem
Thanks in advance!
Bill Brinkworth