Results 1 to 4 of 4
  1. #1
    rkalapura is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York
    Posts
    69

    SetValue Macro action

    Hai, I am using MS Acess 2010. I have a form using to keep some tool records. All tools are validated and if I enter a tool number in this form which is not validated, through a MsgBox function, another form opens for a validation records. Everything is fine. I want to store the tool number I entered in the first form and copy it to the validation form tool number field without retyping it in the new validation form. I am not familiar with code. I am trying to set the value through macro action window, but I cant find "SetValue" action in the list. But I can see it in the "data macro" action list. Appreciate your help to bring the SetValue in macro action list.
    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,903
    With the macro in design view you should see a ribbon item titled Show all Actions.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    rkalapura is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York
    Posts
    69
    Thanks for your help Paul. Problem Solved.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,903
    No problemo!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. PrintOut Macro Action
    By EHittner in forum Access
    Replies: 1
    Last Post: 09-22-2011, 01:27 AM
  2. No SetValue in Macro editor
    By asabri in forum Programming
    Replies: 2
    Last Post: 09-21-2011, 01:39 PM
  3. Problem with SetValue Macro on Form
    By Accidental DBA in forum Forms
    Replies: 3
    Last Post: 04-01-2011, 01:48 PM
  4. Macro Action
    By Bakar in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 12:38 PM
  5. conditional macro action
    By frcastro in forum Programming
    Replies: 4
    Last Post: 06-27-2010, 10:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums