Go To Record function

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Need to create a condition in a macro while using the
GoToRecord>Next function, such that if I am at the end of
the records, that the macro does not run. This would
prevent the annoying "End of Recordset" error messages and
subsequent "Action Failed" message to appear.

Any suggestions?
Tim
 
One condition might be

Forms!FormName.Recordset.EOF = False

If the above expression is True, the recordset is not at the end of the file
marker.
 
Ken Snell:

I need exatcly what Tim request. I'm trying to create a condition but how
do I put that condition on the macro? 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...
 
Back
Top