Help on GoToRecord reaching the last record

V

Victor Torres

I know that people ask a lot of times about this, but I realy don't know how
to do it. I'm not that good with access. I'm trying to create an automated
update condition but I need that the macro stop when it reach the last
record. Can someone help me on this...
 
G

Geoffs

Hi Victor,
Put the update in a Do Loop that runs till EOF
EG:-
Recordset.MoveFirst
Do Until Recordset.EOF
'code to update your data
Recordset.MoveNext
Loop

:)
 
Top