Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Report Criteria in Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennie - 10 Jan 2008 21:43 GMT
I have a form which asks for a beginning date, ending date, and 2 other
criteria to generate a report. When I try to preview the report, a criteria
box pops up asking for the same criteria again. I have checked the
paramaters, unbound text box names, and the criteria in the query, the all
match. Any idea why the query is not recognizing the data entered into the
form?
Douglas J. Steele - 10 Jan 2008 22:14 GMT
While the query may be in use for a form, as far as Access is concerned,
your report is using a completely different query.

The easiest approach would be to create a form with unbound controls to
accept the four parameters. Have your query refer to those form controls
rather than using named parameters (i.e.: rather than [Beginning Date] as
the parameter, use Forms![NameOfForm]![NameOfControl]). As long as the
parameter form is open when your form and/or report is open, you won't be
prompted.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a form which asks for a beginning date, ending date, and 2 other
> criteria to generate a report. When I try to preview the report, a
[quoted text clipped - 3 lines]
> match. Any idea why the query is not recognizing the data entered into the
> form?
Jennie - 10 Jan 2008 22:25 GMT
I have the paramaters entered in as [Forms]![ReportMenu]![BeginningDate] and  
[Forms]![ReportMenu]![EndingDate]. The query worked fine for a year and then
suddenly started doing this.

> While the query may be in use for a form, as far as Access is concerned,
> your report is using a completely different query.
[quoted text clipped - 13 lines]
> > match. Any idea why the query is not recognizing the data entered into the
> > form?
Douglas J. Steele - 11 Jan 2008 11:37 GMT
You say that "a criteria box pops up asking for the same criteria again". If
the ReportMenu form is open, no pop-up should occur. If the form is open,
did the BeginningDate and EndingDate controls perhaps get renamed on the
form?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have the paramaters entered in as [Forms]![ReportMenu]![BeginningDate]
>and
[quoted text clipped - 21 lines]
>> > the
>> > form?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.