reporting based on a question from a survey

  • Thread starter Thread starter reservedbcreater
  • Start date Start date
R

reservedbcreater

i have a housing survey database(it keeps track of housing
inspections/surveys)...and i want to run a report that lists all house's
"funding sources"(one of the questions on the survey)

there are 4 different funding source options i want to be able to select
from a drop down combo box list one of the funding sources then click a
button like "Submit" and have the results come as a listing of all house's
with that particular funding source???

please help detail to me what to do and if possible code to do it i can
provide you with any other details you need to know to help me. please
help, it would be very apprieciated.
 
So, you have a form with a combo box on it (say... cboFunding). You then
select 1 of 4 choices, and then click a button to run the report.
I'm using sample names, you use your own...
Use the value in the combo box on the form to "filter" the records the
report returns.
The RecordSource property for your report should be a query, with all the
fields you want on your report selected there.
In the field that corresponds to Funding, place this criteria...

= Forms!frmYourFormName!cboFunding

That says... "Look at the form, and only return records where the Funding
value eqauls the value that the user selected in cboFunding."
 
Back
Top