macro "Set Value" question RRS feed

  • Question

  • I've got a form where all my reports are located.  I've got two command buttons in the form, one for Print Preview and one for Print.  My actual reports are in an option group where you would select an option button beside a report and then select the Print Preview or Print button to see/print the report selected.  I opened the macro for these buttons and the macro display is alot different than what was in access 2003.  I've got a warning sign saying Set Value right below my submacro Print Preview and submacro Print and apparently I need to enter an Item and Expression before I can save any changes made. 

    The reports are working currently but I was trying to change one of the option group reports to another report but it won't let me save the change until I enter something in the Set Value fields.  What is suppose to go there? 

    Friday, May 13, 2011 6:47 PM


  • Hi there,


    You can use the SetValue action to set the value of a Microsoft Office Access field, control, property on a form, a form datasheet or a report.

    See this article of MSDN on what the SetValue Macro is all about:



    Press F1 (Help) on the SetValue property and read the help info on this.



    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Marked as answer by Bruce Song Friday, May 27, 2011 11:14 AM
    Friday, May 13, 2011 11:03 PM