Cascading Combo Box

[adlit]

Hello all,

New to the site, somewhat new to Access. I can create DBs in Access via the GUI, but have no experience in SQL.

I'm trying to create a cascading combo box so that the DB will be more user friendly. I've tried this with normalized tables, non-normalized tables, etc to no avail. I've also tried reading up on some SQL to do an After_Update event, but I'm unable to get it to work properly.

Is there a way to make cascading combo boxes via the GUI, where I could just type the string into the properties box of the combo box / after update line?

Sorry in advance if this is a stupid question - I've searched through the forums, but every response is in SQL, and with my limited understanding of it, it's hard for me to make heads or tails of what I'm doing wrong.

Thanks!

 

[John Big Booty]

Welcome to the forum.

I'm currently on the road and do not have access to Access so can't take a look at your samples.

However you may find this article helpful in your attempts to understanding Cascading Combo Boxes.

The sample here has a slightly different take on the topic and may be of interest.