Run Macro Repeat Count

  • Thread starter Thread starter Bertie
  • Start date Start date
B

Bertie

Hi, I want to set the repeat count of a macro to be the number of records
in a table - what is the variable for this?

Cheers
 
Bertie,

One approach to this would be to make a continuous view form based on
the table, in the footer of the form put an unbound textbox with its
Control Source set to =Count(*) and then in the Repeat Count argument of
the RunmMacro action, refer to this textbox using syntax such as
=[Forms]![MyForm]![MyTextBox]
 
Back
Top