Stop Macro At Recordset End

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
 
V

Van T. Dinh

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
 
K

Ken Snell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top