Access 2016 - How to Make a City/State Selector (Cascading Combo Boxes)

How to create a form with a State combo box and a City combo box. When you choose a state, only the corresponding cities become available in the second box.

[@toml7682]

I learn from other youtube video, I use foreign key cause me a lot of probem. today I learn new method that actual can apply to my project, thanks so much for your good work!

[@sliverofsilver7123]

Your tutorial was beautiful in its simplicity and how informative it was. Thank you for breaking it down.

[@nicoleleafty1729]

THANK YOU SO MUCH! You made it so easy to apply this to my own database by using the city/state fields!! And it was so easy to follow along with. Thank you, thank you, thank you!!

[@blackstockboy]

Exactly what i was looking for.. and it actually worked! thanks so much.

[@holyonfire]

Your Access videos are very helpful! Thank you!

[@dianemetheny8572]

Thank you for this! I have no idea what I just did but I followed your instructions and it worked :)

[@kimrowisomabes6533]

This is the most helpful video i've seen all day

[@wangzig9800]

An excellent tutorial. Thanks a lot, wish you are well.

[@namariq3177]

Ohhh my god 😩😭 i dont know how could i thank you 😢 i was really confused 😰😥 thank you veeeery much sir 💟💖

[@andrewkirkland6706]

Awesome video! Thanks!

[@TheShaxlupus]

Thanks @Game Design HQX. It helped alot

[@travissimonsphoto]

Good example and concise!

[@alane3983]

Thanks. After a few tries, I got it working. The criteria field gave me problems for some reason. But good now.

[@philr3630]

Nice series of videos. Do Cascading Combo boxes always need separate tables? What if the fields are in the same table? Say the same item is made by different manufacturers. I want to create an inventory tracking form for each separate item/manufacturer.

[@valormiguel1896]

is it possible to cascade combo boxes if the 1st combo box is on a main form and other 1 is on a subform?

[@nicstevens899]

would you be able to assist with getting the unbound combo box data into the table as well, so in the table the city and state data would both be added?

[@davidsisson3190]

Is there a way to move the drop downs to an existing form or create it in one? I've tried copying the drop downs to an existing form, but it didn't work.

[@eliasaouad13]

Thank for this tutorial. I followed the tutorial step by step, but noticed "[City_tbl]![State_Name]=[Forms]![Data_Entry]![Combo2]" will not save in the criteria field when I save and close. Not sure what is going on. hope you can help.

[@warrenjeffries2286]

so heres a question, What about if you have 1 citys in two different states? how would you go about doing that just duplicate the city name and related it via another field?

[@sliverofsilver7123]

Hi, is this possible for combo boxes in a split form context? e.g. combo box 1 is in parent form and combo box 2 is in the subform?

[@tamarigviniashvili152]

Thank you it really works. I am new at access and i dont know a lot of things. I made table with a lot of column one of them are city and state. Than i made two other tables like in video for states and for city and state. I made relationship between those three tables, I made combo box as it is in video but now I want to add information in my first table by using the combo box. When I use this combobox information that I choose is not saved anywhere. May be you can help me.)))

[@bishopminter7793]

I have a VB dashboard that's pulling data from an Access 2016 database. How would I recreate this same effect on the dashboard? I assume it would involve a query instead of a form.

[@NimishP]

@8:26 the last record you added to the table was not yet committed because on data entry grid of the table, you did not leave the row. And that's why, last record was not visible to the form.

[@michaelbranchini9133]

I don't know that not giving the city table a primary key is a good way to go. Should have a unique identifier for each city, incase you need to extend on this, what about the case of a city name that is the same in multiple states? Would work in this example. But suppose you are designing a form, or querying on a city level, you'd be a little hosed up. Even a composite key would be a good idea. Currently working on an access project, have a lot of background in SQL Server and MySQL. I just feel like in the theory, the object of city should have a unique identifier and would be bad practice as implemented here.

[@designanddeploy5991]

Might be worth me posting a follow up where city is designated first. Thinking an example would be driving direction apps like Mapquest where you can designate the city and it gives you a list of the different cities with that name. I do try to promote best practices but I do often speak of the iterative nature of development. So, sometimes for clarity sake I will focus on the core functionality.

[@martinbrien9104]

8.40 ACCESS wasnt being a little WEIRD.. the record for the 6th city was still " DIRTY " .. not written.. hence... wont show in the form until record saved and form refresh :)

[@flapit]

Thanks for this amazing video. I have a problem. I don't need a form. I do need to update a table the same way with Cities and States. For example, I need only the corresponding Cities after I chose the State. Not in a Form, but in a Table. Is that possible? Thanks once again.

[@dianemetheny8572]

I've been searching for the same solution and have come to the conclusion that you must have a form in which to do this. However, you can set up a form to look exactly like your table using the Form Wizard - that's what I'm doing anyway.

[@GayumaTIS]

in a sales report for example, Is it possible to show in a form the results of sales based on a certain month given that there is a drop down box and/or like in a certain time frame like they want find out sales from January to March only something like that? love your work btw, i learned a lot :D

[@designanddeploy5991]

Yes, one way is to have a query where the Criteria field refers to the selected value in dropdown box. When you make a selection, the query runs and outputs to a Report.

[@GayumaTIS]

oohh okay, imma try that, thank you :)

[@101Amystar]

Hey, any chance you can help with append queries? My ICT teacher is even getting stuck with them

[@designanddeploy5991]

Sure, I will post a tutorial tomorrow. I started working on it tonight but ran out of time.

[@designanddeploy5991]

Here you go : kzbin.info/www/bejne/h6nQqHiZmLeMhLs

[@101Amystar]

Thank you!

[@chhansambath5244]

Hi why it not supposed khmer Unicode?

[@TheWheelchairGuy]

My teacher does not know SHIT