how to display recordset in unbound form

[huela]

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

[Hugh Webster]

Continuous forms must be bound, so use something like this.

docmd.openquery "this is a query which deletes all records in a temporary
table"
docmd.openquery "this is a query which appends data into the temp. table"
docmd.openform "this is the form which displays the temp. table data"

Obviously you must create the temp. table beforehand (use a MakeTable
query, and then tidy up the field parameters)

On 12 Oct 2004 15:04:32 -0700, huela <hu*******@yahoo.com> wrote:

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

--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/