Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2006
    Thanked 0 Times in 0 Posts

    pivot tables on subforms - unable to sort (2003)

    Hi i wonder if someone can help,
    I am running a database and one of the front ends has a form (which opens on startup) which displays information in several pivot tables (which are subforms). When you open the pivot table forms separately you can sort them by right clicking, however when they are subforms this is not allowed. I had set the startup options so that menus were disabled, and have tried changing this but it seems to make no difference with regards to sorting?
    is there any way of restoring access to the sort function,
    thank you in advance!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: pivot tables on subforms - unable to sort (2003)

    Welcome to Woody's Lounge!

    I don't think so; apparently the functionality is disabled in pivot table subforms - the equivalent VBA code doesn't work there either.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts