Welcome to SPN

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

Sign Up Now!

Blocking form changes

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

  1. John

    John
    Expand Collapse
    Guest

    Hi

    I have a main form with a sub form (Subform1). The sub form only has a tab
    control on it and then each tab in turn has a sub form on it. I am trying to
    block one of the sub forms on the tab control, so I have tried this;

    Forms![Main]![SubForm1].Form![SubSubForm1].Form.AllowEdits = False

    But this has not worked. Any ideas?

    Thanks

    Regards
     
  2. Loading...


  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    John,

    What event is this code being run from?

    Make sure you are using the names of the subform controls, rather than
    the names of the forms used for the subforms... these are not
    necessarily the same.

    --
    Steve Schapel, Microsoft Access MVP

    John wrote:
    > Hi
    >
    > I have a main form with a sub form (Subform1). The sub form only has a tab
    > control on it and then each tab in turn has a sub form on it. I am trying to
    > block one of the sub forms on the tab control, so I have tried this;
    >
    > Forms![Main]![SubForm1].Form![SubSubForm1].Form.AllowEdits = False
    >
    > But this has not worked. Any ideas?
    >
    > Thanks
    >
    > Regards
    >
    >
     

Share This Page