how to display recordset in unbound form
I have to display disconnected recordset in the form. But I can't make it.
1. I tried use Me.recordset = rs. but it have error after disconnected connection. It works fine before disconnect
2. I test the recordset, it contains all data, i try to use unbound form, but it can only display last record. it always over write previous record.
Does anybody know how to display it?
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 & ":" _