based on combo box selection display report

[rexb]

Hello,

I have a form with a combo box on it. this combo box displays different location. If a location is chosen I need to call a report and display the particulars. Can somebody help me please. I already made the form and combo box and the report it's just that I don't know the code to make it work together.

 

[pbaldy]

One way:

http://www.baldyweb.com/wherecondition.htm

 

[rexb]

One way:

http://www.baldyweb.com/wherecondition.htm

Would this work also on report?

 

[pbaldy]

Yes; I guess I have to somehow highlight these comments from that link:

or DoCmd.OpenReport

As noted above, this technique can also be used when opening reports

 

[rexb]

Yes; I guess I have to somehow highlight these comments from that link:

or DoCmd.OpenReport

As noted above, this technique can also be used when opening reports

sorry about that i don't know how i could miss that, but i need help i've tried putting the code but still doesn't work so I've attached the database can you show me how?

Thank you

 

[pbaldy]

Try this, as your field in the report is the text value, not the ID:

DoCmd.OpenReport "rptLeaseCostbyCity", acViewPreview, , "City='" & Me.cboFindCity.Column(1) & "'"

 

[rexb]

Try this, as your field in the report is the text value, not the ID:

DoCmd.OpenReport "rptLeaseCostbyCity", acViewPreview, , "City='" & Me.cboFindCity.Column(1) & "'"

Thank you so very much. It works.