Get Repeat Count from unbound control in Form

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

Guest

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

Guest

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.
 

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