I have a report that uses a VB macro to turn on subtotals when a field is selected from another table. The bookmarks seem to bypass running the macro. Is this correct?
The best is to avoid macros - see Macros are Bad. In your case you could use your field twice one with subtotals and one without and each with a condition on your mentioned selected field - for this no macro will be needed.
The problem is that the field selected by the user is just a yes/no that kicks off a macro that uses an object to turn on partial subtotals for a category. I don't how to set that setting outside of a macro (other than at initial design).
