Results 1 to 2 of 2
  1. #1
    Andrea is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Mar 2011
    Posts
    6

    Report showing wrong parameter


    I originally created my database tables, queries, reports, etc and had someone helping me. I didn't realize he was using an older version of Access. I am using 2010. He created code to choose a parameter when pulling up a birthday report. For instance, show me all of the people with birthdays in October. He also created a report header that changes the month text title based on the parameter. It worked great before I created the navagitation form and pulled the report in there. Now, the month text title doesn't change. However, the same exact report works fine outside of the nav form - the month title changes - but not in the nav form. Anyone know what is going on?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    I haven't built anything with the navigation form. From what I have seen from other developers, don't think I would use it except for a web db.

    I have built a regular form, created a tab control and put a subform/subreport container control on tab page to display report embedded on form.

    Embedding a report (in navigation form or regular form) has drawbacks if there is a need to print the report as can be seen in https://www.accessforums.net/reports...pdf-28675.html

    Want to provide the db for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report Showing ID number and not the name
    By tipopilotas in forum Reports
    Replies: 11
    Last Post: 07-20-2015, 03:21 PM
  2. What am I doing wrong? Printing a single report
    By sofarfromexpert in forum Reports
    Replies: 1
    Last Post: 07-15-2012, 07:33 PM
  3. Replies: 2
    Last Post: 06-15-2012, 07:32 AM
  4. Number showing in wrong format
    By Douglasrac in forum Database Design
    Replies: 10
    Last Post: 05-26-2011, 05:43 PM
  5. What I am doing wrong? (caption of report)
    By swampdonkey in forum Reports
    Replies: 0
    Last Post: 12-07-2006, 11:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums