Iteration of Recordset

Can someone please show me why this is not working?

I have 5 records in this particular table (on the SQL server side) but when I run the report it's only printing 1 of the 5 records and I cannot seem to be able to move through the recordset and print out all the 5 records.

Any ideas/solutions will be GREATLY appreciated.

__________________________________

With rs
.Filter = "CBranch = "
.MoveFirst
Do Until .EOF
'do whatever you're doing for each record
Field1.DataValue = !CBranch & ""
field2.DataValue = !FY04XP & ""
Field3.DataValue = !FY05XP & ""
Field4.DataValue = !SumOfAGenOff & ""
Field5.DataValue = !SumOfFY04XP & ""
Field6.DataValue = !SumOfFY05XP & ""
Field7.DataValue = !SumOfFY06fAGenOff & ""
.MoveNext
Loop
End With

___________________




thanks in advance

Try moving the .MoveFirst before the With. I think it is always moving it to the First record even though you have a MoveNext at the Bottom the MoveFirst at the top is bringing back to the first record.