Get Repeat Count from unbound control in Form

A

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.
 
K

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.
 
S

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

allen2000

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

Steve Schapel said:
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.
Click to expand...
Click to expand...
 
Top