423,851 Members | 2,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,851 IT Pros & Developers. It's quick & easy.

how to display recordset in unbound form

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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/
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.