Help with form - list of choices

[lios1984]

What I want to do is to create a form where at the first field (Country I choose a country from the list and then at the second field City I choose a city that depends on the chosen Country. For example, if I choose Italy, then at the field City my list will have only Rome or Venice to choose (as I put it in the test file).

Reading several posts, I found that this can be done by modifying the attributes of the list boxes but there are errors that I cannot surpass.

I attach a test file of what I am trying to do. Could anyone please help me find the error or give me another solution to the problem?

[June7]

This is cascading (dependent) comboboxes. Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section.

[lios1984]

Thank you very much for the videos. They have been really helpful. But I still have a problem with the Requery part. I follow the instructions as said on the video but Requery doesn't work. Is there any other way??

[June7]

What do you mean by doesn't work - error message, wrong results, nothing? If properly set up, the technique does work. No, I don't know any other way to produce this behavior.

If you want to provide project with your effort, I will look it.

[lios1984]

OK give me 2 minutes to attach a file

[lios1984]

Here it is. There is no error message, it just doesn't refresh the list of Cities when I choose another country.

For example, I choose England and english cities come below. When I choose France, english cities still come below.

[June7]

Don't know what to say. Your form is working perfectly for me. Except the country and city comboboxes are not bound so data is not saving to table.

[lios1984]

What do you mean "not bound"?

[June7]

They don't have ControlSource property set to field. The Description combobox is bound.

[lios1984]

I see. I have to set ControlSource to the matching field, right? Did that but still nothing.

This is very important for me. It's the last important thing to do before my project is concluded and I start entering my data.

So if you have any advice, any at all, please help me.

[June7]

If I can't replicate the issue with your project I can't say why it is not acting right for you.

I select a country and the cities list is correct for that country. I select a different country and the city combobox requeries and list is correct for that country. However, the value in the city combobox, if there was one, is not changed. It would be a good idea to null this value when the country is changed: Me.cmbcities = Null

I did find an error in the Lookup set for the Country field in the Data table that seemed to interfere after I added the above code. I never set Lookups in tables. Fix that one or remove them and see if the form behavior is better.

[lios1984]

It seems to work now!!
Thank you for everything.