Somehow i have to display the recordset in unbound form
When i use the following display the data in recordset to unbound
form.
I have a question:
i can only display the last record data, all previous data are
overwrittend. why i can't create the continues form or datasheet
display the data line by line.
Thanks a lot for the help
Do Until Rs.EOF
frm.Fund = Rs.Fields(0).Value
frm.Deal = Rs.Fields(1).Value
frm.[Deal Name] = Rs.Fields(2).Value
MsgBox "recode is: " & Rs.Fields(0).Value & ":" & Rs.Fields(1).Value &
":" _
& Rs.Fields(2).Value
Rs.MoveNext
Loop