Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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. Ron2006

    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...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page