Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Passing dinamic data to a report


    Anybody knows of a way to pass a dinamic value to a report?

    While processing invoices I have a report that prints a hard copy
    of an invoice being processed.
    I can't seem to find a way to pass 'Invoice ID' to a report to look up
    and calculate all other fields.

    It works if I use a static value:
    intCompanyID = DLookup("[Company ID]", "[Invoices]", "[Invoice ID]= 12") where '12' being a static value of a 'Invoice ID'
    I need to dinamically pass that value to a report.

    Any idea anybody?
    Last edited by sup; 01-05-04 at 06:05. it, gimme a beer... Jimi Hendrix RULES!

  2. #2
    Join Date
    Sep 2002
    South Wales

    Report query

    If the report is based on a query, perhaps you could refer to the form value in the query criteria:


    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

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