Combo boxes on a report

[zufie]

I have 4 combo boxes on a report for the fields, City, County, IBCCP
Agency Name, and Other Agency Name.

The row source for City is: SELECT DISTINCTROW [Cities].[ID], [Cities].
[City] FROM [Cities];
This allows the values selected on the combo box on my main form to
show up on my report.

The row source for County is: SELECT DISTINCTROW [Counties].[County
Code ID2], [Counties].[County] FROM [Counties];
This also returns the values selected on the combo box on my main form
to show up on my report.

However, I am not successful in getting the correct row source for the
fields, IBCCP Agency Name, and Other Agency Name.

Can you help point me in the right direction?

Thanks,

John

[Phil Stanton]

You can't have a combo box on a report. I know theoretically it appears
there, but use a text box instead. The report should be based on a query
that has all the results of the lookups displayed.

So if your form uses a combo box to select a county, you probably have
CountyID in the recordset for the form, but you would not have the Table
Counties.

In the query for your report, you would have your main table and the
counties table (suitably linked together) and show the name of the count

HTH

Phil

"zufie" <jo***********@illinois.govwrote in message
news:cd**********************************@8g2000hs e.googlegroups.com...

>I have 4 combo boxes on a report for the fields, City, County, IBCCP
Agency Name, and Other Agency Name.

The row source for City is: SELECT DISTINCTROW [Cities].[ID], [Cities].
[City] FROM [Cities];
This allows the values selected on the combo box on my main form to
show up on my report.

The row source for County is: SELECT DISTINCTROW [Counties].[County
Code ID2], [Counties].[County] FROM [Counties];
This also returns the values selected on the combo box on my main form
to show up on my report.

However, I am not successful in getting the correct row source for the
fields, IBCCP Agency Name, and Other Agency Name.

Can you help point me in the right direction?

Thanks,

John