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

Row Source

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
Instead of using a combo on the report, create a a query that uses both the
Cities and Counties table, and use that as the RecordSource for your report.

If you run into problems wih cities that don't have a county defined, use an
outer join. More info:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"zufie" <jo***********@illinois.govwrote in message
news:63**********************************@y38g2000 hsy.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.