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

Cascading combo/listboxes

P: 40
Hello all,
I am fairly new to Access. I have a decent understanding of database concepts from working with sql developer and Oracle's APEX. In MS access, I would like to know how to populate a list from a list of values (maybe a combobox in Access?) On my form, I have a combobox that has values from a "Letters" table, which is A-Z. I would like to know how to populate a listbox/combobox to retreive Employees names (Last name, First, name) based on the chosen letter in the first combobox (is this called cascading?).

I guess a more straight-forward question would be 'Is this possible to do in a sql statement, or would it have to be done in VBA by calling the objects and so forth?'

Here's a pic just to clarify:
http://img2.freeimagehosting.net/ima...76a363eac5.jpg

I would like to be able to do the same thing with the dept# there as well. The user would select a Dept# and the list box would populate the names according to those in the selected department.

I have taken classes in Java, C++, and SQL/Oracle so don't hesitate to get a litle technical.

Any links, info, tips, or advice would be much appreciated.

Thanks for your time,
LordRahl
May 30 '07 #1
Share this Question
Share on Google+
1 Reply

Rabbit
Expert Mod 10K+
P: 12,441
Take a look at this tutorial: Cascading Combo/List Boxes
May 30 '07 #2

Post your reply

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