Microsoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo Box

Thank you Sir, your videos have been so helpful to me. God bless you Sir 🙏

I want to ask question about cascading combo boxes per video available the layout of the forms are columar so it work perfectly but if the layout is Tabular when you select one it automatically select for other records or other line. And want to know if you can help me solve that problem. Thank You

Is it possible to copy and paste these combo boxes onto another form? Instead of having to do the entire process all over again.

hi sir, nice to watch thanks,. but when I open table there in state field has number . ?

Well, I don't know if you needed an ego boost today Richard, here comes one. Years I've tried to get my head round this Access stuff. YEARS. I have many books that are each almost too wide to pick up with one hand at the spine. Some are called bibles, and are fatter than actual bibles. Bound them in leather and you'd call them tomes. You could stack them up and measure the height in feet and inches.

I've read every page of these manuscripts. Probably millions of words, over years. Filled multiple Moleskines with notes. I would not consider myself a super user by any means, but I am better than your average Access user I would say.

Anyway, point being, I watch your videos, even the real easy ones, and I still learn stuff. I watched all 4 hours of the absolute beginner video, and STILL learned things. So got myself a shiny membership and probably learned more skills in the last month than the last 4 years. Most importantly, for me at least, your method has ensured I retain this knowledge.

So just thought I'd say thanks for that. love your teaching style and technique.

How do I make the combo boxes work in a subform?

Hello Richard, These comboboxes are all in relation to each other. However in the application that I have in mind some of information (records) will be deleted in the future due to the certain events. So when you delete a record your database will only show a number but you may never find the 'description' of that number again. So my question is can you do this cascading also without relations so that in the end only your plain selection will be in the database. (Pff maybe confusion explanation but I hope you get it).

Sir I want cascading combo box in continues sub form how can I do?

New subscriber and member here - this content is excellent

How can You connect 4 Combo boxes instate of 2?

hi sir,
your video is very informative bu i have a question that how we can cascade combos in a continuous form as they create problems. because as we move to next record on same form and change value of a combo box it also changes previous combos too
solution please.....

Thankyou for your expertise. I have been using access/vga for a long time. It only goes to proof that you can teach an old dog new tricks

Thank Ian😀

No relationship established between customer table and city table?

Cascading Combo Boxes and Split Forms?

The edit list option doesn't work, after the .accdb is converted into .accde file.
The same happens with list box too.....
Pls advice way forward....

thanks a lot sir, that's awesome

Hi Rich, can you cover how to create cascading combo boxes on a continuous form? On a continuous form, when you change the parent combo box it will requery all of child boxes on the form rather than just the child box on the current record!

thank you very helpful

I tried this in the subform of an orders form. However, everytime I open the orders form the criteria box for the subform pops up and I'm starting to think there is a problem with the Access program itself. Another DB I've been using for a year is now not working properly even though I haven't changed anything.

The state is being stored as the ID Number rather than the name. Is there a way to get it stored as the actual state name?

OK, stop making that many videos! just kidding, really appreciate all the help! Saludos desde México!

This tip is amazing. Just solved a major issue for me

Amazing. I have been looking for this for 2 months until i found this video. Thank you.

I there a way to may data base or form in access to look like full screen. Kind of power point. The idea is to make it look like an app or program instead of working within ms access GUI itself?

It Helped me a lot.... Thank you:)

😊

Dang good stuff
VERY helpful!!

I have followed this exactly, however my child combo box (the city selections), does not allow me to select other options, other than the top presented field. Example i can only select Buffalo, i cannot select Rochester or Syracuse. Where have i gone wrong and how do i fix this?

No matter what I try the combo box populates but I cannot select anything in it. I've followed everything to a t, so annoying

Thank you so much Richard. I just made a 4 levels cascade COmboBox, with 2 fields each (tag and title one). Now heading to create a a concatainer from the TAG field to create a code, similar to a serieal number. Stay tune for my progress

i have a problem, the combobox cascading effect works pefectly, but when i save the records, instead of the city names and the state names i get the id's

SOS! I used this lesson because there was just 1 thing for my query I wanted to use. I only got as far as Expert 3, and tried to build a form where I choose a date, and another combo filters events (calendar terms, not 'access event') on a schedule. It works and filters, but something happened and now it won't allow me to click on the schedule event combo box. The filter still works, but I can't click it to update info. Does this sound like a familiar problem?

You super teacher in Access number one in my playlist😊

If you change the value in the 1st combo box the second looks blank (after re-query) but it still has stored the previous value in the table. Making it a required field doesn't help as it has the previous value stored. Is there a way to refresh the table value also? How can you solve this problem?

thank you very much, but if we use it, the costumer table , will show 1,2,3 not the name of state. can you please tell me how to appear name of the state and the city?

Doesn't this allow for duplicate cities in the StateT?

Thanks for the tutorial. I'm having an issue. I set up linked Country > State/Territory combo boxes on a subform. The main form contains organization info then the address subform is on a tab control with other tabs containing other info about the org (e.g., personnel; stats about the org, etc.). When I try this using the actual address subform, it works. However, when I open the main form and run the base query for the State combo box, I get prompted for parameter value. Not sure why this is happening. Any ideas? Thx.

Really good! Saved me since I couldn't find this in any of my textbooks.

Like always … you are amazing …

Thanks, that was very helpful. When I type the VBA code to requery the city combo box, it doesn't work. If I change the state, it doesn't refresh the cities. It only refreshes when I reload the form, as you would expect. The code is definitely saving. Access is definitely recognising the code because it suggests the requery function as I am typing in the code. I would be grateful for any advice.

Hi, how to make cascading comboboxes work on continuous forms? :(

Too bad this doesn't work in datasheet view on your form.

Thank you Sir, fantastic content.

Is there a way to do this across multiple forms without creating a new query for each form it is used on? Like say you use it where you have it in the video in a customer form but then also using the same dropdown boxes in a continuous form to filter.

nice shoutout Corpus Christi!!

i live in corpus christi! lol

This is wonderful work our instructor Mr Rost 👊

Thank you, your video's are the best!!!

I need your help for access software for my business. How much & where to pay for your premium membership? Or i may have free guidance?