Results 1 to 2 of 2
  1. #1
    RLehrbass is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    102

    Question report header question

    I have a table 'tblOrganizationInfo' that only has 1 record and contains the OrganizationName, PAddress, phone and email I want to use for my header and theOrganizationName and MAddress on the footer for each Invoice produced.
    (I have it as a table so the Organizations contact info can easily be updated as needed.)
    Question:
    How do I populate the header/Footer of 'rptInvoiceBalDue' to utilize 'tblOrganizationInfo' on each member record with a balance due,


    do i simply assign the fields like the rest of the report or do I have to dim and set as veriable in VBA?

    What would be the correct method and if in VBA, what would this look like?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    Options:

    1. include the table in the report RecordSource without a JOIN, the one record should associate with every record of the 'primary' dataset

    2. DLookup() expression in textboxes: DLookup("OrganizationName", "tblOrganizationInfo")

    3. Pass the values to report in OpenArgs and the set textboxes equal to parts of OpenArgs

    I'd go with 1 or 2.
    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 Header
    By BorderInfo in forum Reports
    Replies: 1
    Last Post: 02-14-2015, 03:32 AM
  2. Replies: 4
    Last Post: 11-24-2012, 09:42 PM
  3. Replies: 2
    Last Post: 06-15-2012, 07:32 AM
  4. Report Header
    By kwooten in forum Reports
    Replies: 2
    Last Post: 08-03-2011, 11:31 AM
  5. report header
    By nashr1928 in forum Reports
    Replies: 2
    Last Post: 07-13-2010, 12:34 PM

Tags for this Thread

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