Prevent data field movement in subform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Qtip23
    New Member
    • Apr 2010
    • 39

    Prevent data field movement in subform

    Hi,

    I would like to prevent movement of the category, axis, data and filter fields of a Pivot Chart in a subform. I do not want the user to tinker and begin moving data fields (e.g. SumofTotal).

    The idea is for the user to view the displayed bar charts in this subform.

    While the subform is based on a query, I do not see any property in design view that would stop a user from manipulating these fields.

    What subform properties should I be using?

    Thanks,
  • Narender Sagar
    New Member
    • Jul 2011
    • 189

    #2
    Set its Enable Property to No, and check.
    regards
    Last edited by Narender Sagar; Aug 19 '11, 03:44 AM. Reason: spelling mistake

    Comment

    • Qtip23
      New Member
      • Apr 2010
      • 39

      #3
      @Narender

      Hi --

      So I think what you are saying is that this feature can only be set through VBA coding, right?

      For example, something like: Graph24.Enabled = False

      Will try and see what happens.

      Thanks,

      Comment

      • Qtip23
        New Member
        • Apr 2010
        • 39

        #4
        Wow, it's amazing what you can find when you look a little deeper. LOL.

        Actually, I found all the properties I needed when I clicked on the subform. I opened the Property Sheet utility of Access and it had all the options I was looking for.

        There are Show by Default and Let users view options.
        I was able to deselect Field List.

        Works like a charm.

        Thanks.
        Last edited by Qtip23; Aug 19 '11, 02:52 PM. Reason: spelling error

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32636

          #5
          Sounds like you learned something very important today :-) The existence of the Properties pane and how much information and control it enables. Good for you.

          PS. In case it needed saying explicitly - changing these properties is not restricted to VBA code but can also be done from the Design user interface.

          Comment

          Working...