Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Easy MACRO Question

Discussion in 'Information Technology' started by Brian B, Jul 28, 2006.

  1. Brian B

    Brian B
    Expand Collapse
    Guest

    Hello,
    I'm trying to implement a MACRO that seems pretty simple. When I check
    on a checkbox in my ordering form, I want a subform to become visible.
    I've got the subform default as MODAL, I can handle that part, I don't
    think there's anything else I need to do there...but when I check on
    the checkbox to which I've applied a SET VALUE MACRO with
    ITEM: [Forms]![SubForm Title]
    Expression: [Forms]![Sub form Title].Visible

    to occur ON Click when I check on the approved button, I get "The
    object you reference in the Visual Basic Procedure as an OLE Object
    isn't an OLE Object."

    Please assist.

    Just learning to walk at this point.

    -Brian B
     
  2. Loading...

    Similar Threads Forum Date
    Why Its Easy To Be A Sikh And The Master Of Puppets Blogs Oct 17, 2015
    Easy, Develop Another Addiction! Blogs Oct 16, 2015
    How To Conquer The World: Easy (by The Poet Warrior) Sikh Youth Feb 23, 2013
    USA Not Easy To Divide Wisconsin Sikh Gurdwara Shooting Donations Breaking News Sep 6, 2012
    Opinion Human Evolution: No Easy Fix Breaking News Oct 5, 2011

  3. OP
    Ron2006

    Ron2006
    Expand Collapse
    Guest

    If the subform is already on your main form, but simply not visible,
    you do not need a macro.

    In the onclick event simply say

    me.[subform name].visible = true


    You may also have to put in the oncurrent event of your main form
    me.[subform name].visible = False
    otherwize once it is on it will stay on.
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page