By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Combo boxes on a report

P: n/a
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
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Sep 20 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.