create report from a drop down selection 1

[1angryadmin]

I have been asked to create a report that spits out all the sales contacts from a given state.

They would like an easy form where they use a drop down to select the state they want the contacts from and then just a print button.

2 tables involved:

tblcustomer
tblcontact

common field bewteen them is customerID
and the tblcontact has a field name states.

please help it is hurting my head....

 

[dhookom]

Do you have a report created? Do you have a form with a combo box of states? Usually this only involves adding a criteria to the report's record source query under the State field like:

Forms!frmYourForm!cboState

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[1angryadmin]

Thank you for your reply

i have the report created.

i also have the query created but i didn't know what to add as a criteria for the states field.

i don't have the form created and that is really where i am stuck. I don't have much expirence with creating access forms.

in your response you say the criteria should be:

Forms!frmYourForm!cboState

what does the cboState mean?

I understand Forms!frmYourform tells it the data is coming from a form named frmYourForm.

 

[1angryadmin]

ok i have a basic form created.

i have a button which runs this report.

the report currently spits out all states.

so if you could just explain how i can best change the form and the query so filter for state via a dropdown i should be in great shape.

 

[1angryadmin]

sorry if it seems like i am frantically posting but i am activly working on this problem...

i am trying to figure out how to add a drop down to the form

and i can not find it...this should be easy but i have a limited IQ hehe...

 

[1angryadmin]

ok i have the drop down on the form being populated with the state names.

I have a command button which previews the report.

but the query does not seem to care about my drop down list...

 

[1angryadmin]

problem solved thanks!

i would not have been able to do it without your tip on

Forms!frmYourForm!cboState

 

[dhookom]

Wow, I am busy at my day job and you have seemed to work throught this. Congrats.


Duane
MS Access MVP
Find out how to get great answers faq219-2884.