Goto NextRecord and Working with RecordSet (1 Viewer)

[guiderec]

Hi,

I have a problem with recordset and gotorecord method.

I used to me.recordsetclone.MoveNext for going to next record. Than i look the Me.MyTableColumnName, but it was not cahnge. It show me previous record's value. But I stay in While..wend loop when me.recordsetclone.EOF and i exit the while wend. There is no problem but Why i can't see new row's value?

Please help me immediately.

Thanks.

 

[doulostheou]

I am not quite sure what you are asking and I am not particularly good at working with recordsets. But if your trying to move to the next record, why don't you just use DoCmd.GotoRecord,,acNext?