[RESOLVED] Creating a text file from a recordset

[beatlesgal25]

Hi there

I have a table in Access 2002 and I need to create a text file from a recordset in VB6. I have set up the connection (and so on) but when I try to read the values from the recordset into a label, only the last value is displayed - as if the other values are being overwritten.

I know the values are there as I have tried using a msgbox and this displays them fine.

Below is the snippet of code I am using:

Do While Not rs.EOF
    label1.Caption = rs.Fields("order_item").Value & vbCrLf
    rs.MoveNext
Loop

Can anyone help me please? This might be a really simple question, but I'm not the best of programmers.

Many thanks!
Emma.