Using a combo box to select criteria for a form, then basing a report on this.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please can anybody tell me the ID of a knowledge base article that will help me with the above problem? (ie. Using a combo box to select criteria for a form, then basing a report on this.)
Thank you in advance
Alicia
 
Hi Alicia

here is a copy of a post that i posted in response to a very similar
question to yours, it was on specifically using a date as a criteria - but
it will work for any field

----***
to get you started, create a query and in the CRITERIA line of the date
field (the one you want to use as the input parameter) type
[Enter Date]
now run the query and you will see that you are prompted to enter the date -
now build a report based on this (using the report wizard) and then when you
run the report you will be prompted for the date

then to make it nice and neat, create a form with an unbound text box (and
name the text box something like RPTDATE) then, go back to the query and
change the criteria to
Forms![whatever you called the form with the date on it].RPTDATE (use the
expression builder to get the exact syntax)

- put a button on this form - use the command button wizard, choose Report
Operations - Preview a Report (or whatever the exact wording is) - select
the appropriate report

now when you open the form, enter the date, press the button - the report
will display the information you want

---***

hope this helps
Cheers
julieD


Alicia said:
Please can anybody tell me the ID of a knowledge base article that will
Click to expand...
help me with the above problem? (ie. Using a combo box to select criteria
for a form, then basing a report on this.)
 
Thank You this worked just fine,

----- JulieD wrote: ----

Hi Alici

here is a copy of a post that i posted in response to a very simila
question to yours, it was on specifically using a date as a criteria - bu
it will work for any fiel

----**
to get you started, create a query and in the CRITERIA line of the dat
field (the one you want to use as the input parameter) typ
[Enter Date
now run the query and you will see that you are prompted to enter the date
now build a report based on this (using the report wizard) and then when yo
run the report you will be prompted for the dat

then to make it nice and neat, create a form with an unbound text box (an
name the text box something like RPTDATE) then, go back to the query an
change the criteria t
Forms![whatever you called the form with the date on it].RPTDATE (use th
expression builder to get the exact syntax

- put a button on this form - use the command button wizard, choose Repor
Operations - Preview a Report (or whatever the exact wording is) - selec
the appropriate repor

now when you open the form, enter the date, press the button - the repor
will display the information you wan

---**

hope this help
Cheer
julie


Alicia said:
Please can anybody tell me the ID of a knowledge base article that wil
Click to expand...
help me with the above problem? (ie. Using a combo box to select criteri
for a form, then basing a report on this.
 
Back
Top