records to report detail

[Tony Piperato]

Greetings,

I am opening a recordset and would like to print the results in a report
detail section to the txtDateStart and txtDateStop text boxes. I have the
following code:

Do Until rsMyRS.EOF
txtDateStart = rsMyRS("DateStart")
txtDateStop = rsMyRS("DateStop")
rsMyRS.MoveNext
Loop

There are nine records in this particular recordset (there could be
infinitely more), but I only get the first records' values printed nine
times instead of EACH individual record. Any thoughts?

Thanks in advance for your help.

Tony

 

[Leonard Selmani]

Do Until rsMyRS.EOF

txtDateStart = rsMyRS("DateStart")
txtDateStop = rsMyRS("DateStop")
rsMyRS.MoveNext
Loop

--How are you opening your recordset? Are you selecting *
from....

What's with the txtDateStart? Try Debug.Print (rsMyRS
("DateStart")), otherwise you're replacing the value of
the text box with the next record every time. Post the
rest of the code so I can see what you're trying to do.
The loop seems to be fine.