Making a simple access combobox and form

[dukati7]

I'm pretty new to access and need big time help

If I wanted to create a thing that would have all 50 states, and then another table populated with cities. How would I make it "step by step" so that I come to a form that has 2 drop down boxes with one being the states and one showing the cities in that state.

But I want to make it so when I choose PA from a drop down I can only see cities from PA and so on.



It would be a great help if someone can tell me step by step just so I understand it better.

Thanks!

[John_G]

Hi -

What you need to do is reset the row source for the cities combo box, each time you update, i.e. select from, the state combo box. You would best do this in the After_Update event of the state combo box, something like this:

me!cboCityList.Rowsource = "Select CityName from tblCities where CityState = '" & cboStatelist & "'"
me!cboCitylist.requery

HTH - post back if you need more detail.

John

[dukati7]

I actually need to start from the beginning with actually making the tables and relationships. From scratch. I can never seem to get it to work.