Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    2

    Unanswered: Form with reporting from two different forms

    Please look at my form. I need the FCC Member form to print certain data on the heading of the New Entry form report. I also need to limit the number of entries it prints. I know about query but can not do that because it is two different form. I need this because we will be adding on to it every month. If anyone has a better idea I am all ears. Thank you.

    drivingdirectory.com/new.zip

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Have you tried querying the tables instead of the forms? Much better way of doing it
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Erm... that database is in a shocking state.

    * Get rid of the lookups in the table design.
    * Modify your tables to conform to good database design fundamentals.
    * Don't put spaces in Fieldnames. Access might allow it, but in all honesty, it shouldn't. Same for table names.
    * Relate your tables.
    * New Entry is not a good name for a table... where are the old entries? I would have named that table "Call" personally.

    Study out relationships and table design and then study out queries and the answer should become clear.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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