Get Repeat Count from unbound control in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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]
 
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...
 
Back
Top