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

Access 2007 Cascading combo boxes question...

P: 4
Hi All,

I am a GIS analyst with zero experience working with Access. Everything I do know has been 'self taught' by browsing websites like this one.

So we're off to a good start, right?

My problem:

I have a form with 2 combo boxes. I have Combo1 set to show the field list of my table. It works great.

What I would like Combo2 to do is show the distinct values available in the field selected by Combo1 - so for instance, if I select "Date" from Combo1, I want Combo2 to list all of the distinct dates in the "Date" field. If I select "Location" in Combo1, I want Combo2 to list all of the distinct locations in the "Location" field, etc.

Once I figure that out (or once I am shown how to do it by one of you fantastic people), I will want to use the values of both combo boxes in a query, but I'll worry about that later.

Clear as mud? Great.

Any help would be greatly appreciated!

Cheers,
Jason
Jun 11 '10 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Jason

Check out this article on Cascading Combo/List Boxes. It should at least get you started. Let us know if you have any questions or run in to any problems.

Mary
Jun 11 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.