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

    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

    Expand Collapse

    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