Stop Macro At Recordset End

[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 Snell]

Your example is correct.

 

[Van T. Dinh]

Ken

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

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

????

--
Cheers
Van

Your example is correct.

--
Ken Snell
<MS ACCESS MVP>

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 Snell]

I believe both will work:

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

or

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

Ken

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

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

????

--
Cheers
Van

Your example is correct.

--
Ken Snell
<MS ACCESS MVP>

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