Get Repeat Count from unbound control in Form

[allen2000]

Hello, and this is my first post
How can I grab a numerical value from an unbound control on a Form, to use
as the repeat count for a Macro?
many Thanks.

 

[KARL DEWEY]

When using it in a macro condition use like this but with your form and
control object names --
[Forms]![YourFormName]![Your Control] < X

Replace "X" with your number. You create the condition expression that will
evaluate to be true.

 

[Steve Schapel]

Allen,

If the macro is being triggered via an event on the same form as the
unbound textbox, then in the Repeat Count argument of your RunMacro
action, simply put the equivalent of this...
=[NameOfYourUnboundTextbox]

 

[allen2000]

That is too simple
Many thanks to both of you for your replies.

Allen,

If the macro is being triggered via an event on the same form as the
unbound textbox, then in the Repeat Count argument of your RunMacro
action, simply put the equivalent of this...
=[NameOfYourUnboundTextbox]

--
Steve Schapel, Microsoft Access MVP

Hello, and this is my first post
How can I grab a numerical value from an unbound control on a Form, to use
as the repeat count for a Macro?
many Thanks.