Help with Recordsetclone and DAO.Recordset
Posted on 2004-08-26
Hi there I use the following code to report via message box.
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
Do While Not rs.EOF
MsgBox "Card: " & rs!CardID & vbNewLine & _
"Usage: " & rs!Usage & vbNewLine & _
"Description: " & rs!CardDes
Set rs = Nothing
The code runs well through the recordset that is diplayed on the form. But if i change the last record on the form it does not display the change in my message box and will still use the old info, only when I move the focus to a previous record and run the code again does it display the correct info. Is there a way of updating or requering the recordsetclone before i run the code.