Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Thanked 0 Times in 0 Posts

    Report opens differently from form (Access 2000)

    Subject edited by HansV - "Solar" (your user name) is not a very descriptive subject for a post about Access

    Why is it so that when i open the report by itself it opens with all the records, while when i open it through the form, it shows only the first record?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Report opens differently from form (Access 2000)

    Look at the On Click event procedure of the command button Command15. It filters the report to display only the orderid from the current record in the form:

    stLinkCriteria = "orderid = " & Me![orderid]
    DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Posting Permissions

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