Running report from subform

Results 1 to 2 of 2

Thread: Running report from subform

  1. #1
    Join Date
    Dec 1969

    Default Running report from subform

    I am trying to run a report from a subform, filtering the data on a field in the subform. I refer to this in the report query as:<BR><BR>[Forms]![frm_Contacts]![Subscription].[Form]![Subscription_Ref]<BR><BR>Where frm_Contacts is the main form, Subscription is the control name of the subform and Subscription_Ref is the value I want to filter on.<BR><BR>However every time I click on the button in the form to run the report, I am prompted to &#039;Enter Parameter Value&#039; for the above reference. <BR><BR>Can anyone tell me what I&#039;m doing wrong?

  2. #2
    Join Date
    Dec 1969

    Default You're probably better off...

    ...posting this in a Microsoft Access specific discussion forum. This one is more about using ASP and SQL to get data out of a database, rather than designing forms, reports, etc. in MS Access.<BR><BR>Oliver.

Posting Permissions

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