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?