Re: Report Criteria: Query works, but report doesn't call up query???
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 10/15/04
- Next message: Wayne: "Automatically populate combo box"
- Previous message: Dan Artuso: "Re: Problems with Autonumber"
- In reply to: BARKAROO: "Report Criteria: Query works, but report doesn't call up query???"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 15 Oct 2004 17:31:32 -0600
On Fri, 15 Oct 2004 09:33:08 -0700, "BARKAROO"
<BARKAROO@discussions.microsoft.com> wrote:
>I'm trying to create a report where the the user can enter criteria
>(beginning date, end date) to generate a report.
>
>*I've created a form to enter the criteria. (with macros "ok", "cancel").
>*I've created the query to generate the report.
>
>The query itself works. The form opens and allows me to enter the criteria.
>
>However, they don't seem to work together. When I open the form, enter the
>criteria, and click "ok" (macro), it doesn't seem to know to run the query.
>Instead, it pulls all of the records from the record source. How can I get
>the criteria form to work with the actual query - and get it to show in the
>report????
>All advise is greatly appreciated.
You don't need to "run" the Query at all. Instead, change the Report's
Recordsource property to the name of the query. The macro behind your
button should simply open the Report - which will in turn call the
query.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
- Next message: Wayne: "Automatically populate combo box"
- Previous message: Dan Artuso: "Re: Problems with Autonumber"
- In reply to: BARKAROO: "Report Criteria: Query works, but report doesn't call up query???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
