Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    127

    Answered: Pivot Table Field List for Form

    All,
    I build a Pivot table form pulling data from a query. The first run it worked fine, but since then the Pivot Table Field list does not come up. You can get creative to get it back but other users may not be able to do it so easy. Any suggestions to ensure on form open that the field list opens?

  2. Best Answer
    Posted by ranman256

    "using pivots on forms is not the best idea.
    if you want to display a crosstab query in a form, you need to build a 'report' table that has every possible outcome from the pivot.
    append the data to the 'report' table
    then show it on the form.

    crosstab queries, (pivot tables) , work best as queries only."


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    630
    Provided Answers: 35
    using pivots on forms is not the best idea.
    if you want to display a crosstab query in a form, you need to build a 'report' table that has every possible outcome from the pivot.
    append the data to the 'report' table
    then show it on the form.

    crosstab queries, (pivot tables) , work best as queries only.

  4. #3
    Join Date
    Sep 2017
    Posts
    4

    Thanks!

    I'm posting so when someone else answers, I'll know what to do in case I have this problem in the future.

Posting Permissions

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