Results 1 to 4 of 4
  1. #1
    Join Date
    May 2005
    Posts
    119

    Angry Unanswered: SetValue?? in 2010. What's the equivalent command in a macro?

    In Access 2007, we used a "setvalue" function in a macro. What is the equivalent function to set the value of "onclick" for specific items on a form?

    For example, I have a form that is used for multiple purposes. I use the onopen statement to change the button to do a different procedure based upon the paramater passed.

    My 2007 macro looked like this:
    Action: setvalue
    Item: [Forms]![Results]![close].[onclick]
    Expression: "=sendreports()"

    I don't have a setvalue command in macros for 2010. What do I use now? I tried setparam, but it erred on my onclick item.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    May 2005
    Posts
    119
    PERFECT!! Thank you so much!!!!

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •