Stop Macro At Recordset End

  • Thread starter Thread starter Casey
  • Start date Start date
C

Casey

Hi,

If I use something similar to


[Forms].[form1].Form.Recordset.EOF = True

as the "repeat expression" condition which evaluates to
False to stop a macro, should I use the name of the
recordset for that form, or the actual word "Recordset"
as is in the example above.

I appreciate any opinions.

Thank you,

Casey
 
Ken

I don't think Casey mentioned "Subform" so I think it may be:

[Forms].[form1].Recordset.EOF = True

????

--
Cheers
Van


Ken Snell said:
Your example is correct.

--
Ken Snell
<MS ACCESS MVP>

Casey said:
Hi,

If I use something similar to


[Forms].[form1].Form.Recordset.EOF = True

as the "repeat expression" condition which evaluates to
False to stop a macro, should I use the name of the
recordset for that form, or the actual word "Recordset"
as is in the example above.

I appreciate any opinions.

Thank you,

Casey
Click to expand...
Click to expand...
 
I believe both will work:

[Forms].[form1].Recordset.EOF = True

or

[Forms].[form1].Form.Recordset.EOF = True
--
Ken Snell
<MS ACCESS MVP>

Van T. Dinh said:
Ken

I don't think Casey mentioned "Subform" so I think it may be:

[Forms].[form1].Recordset.EOF = True

????

--
Cheers
Van


Ken Snell said:
Your example is correct.

--
Ken Snell
<MS ACCESS MVP>

Casey said:
Hi,

If I use something similar to


[Forms].[form1].Form.Recordset.EOF = True

as the "repeat expression" condition which evaluates to
False to stop a macro, should I use the name of the
recordset for that form, or the actual word "Recordset"
as is in the example above.

I appreciate any opinions.

Thank you,

Casey
Click to expand...
Click to expand...
Click to expand...
 
Back
Top