Unanswered: question for display recordset in unbound form
When i use the following display the data in recordset to unbound form.
I have two questions:
1. one is i can only display the last record data, all previous data be overwrittend. why i can't create the continues form or datasheet display the data line by line.
2. second, when movenext till last record, it always give the error:
either BOF or EOF is true, or the current record is deleted. Requested operation requires a current record.
what's wrong with it. why i can't detec rs.eof to end the loop?
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 & ":" _