I have a table with cost of living for every city in a region. I am trying to create a form which has a list box for Country, State & City, with State and city list box being disabled at first. So, when i first select the country name, the state list box has to become active and list all the states in that country alone, and after choosing the state the city list should list the various cities in that state alone.

Autofilter does that but I want to setup a form which will pull this info into a worksheet to do some calculation based on it. I would appreciate if someone could help.

Thanks.

Iam not sure if your are referring to data form. You can use it for setting criteria and display one record at a time

Actually, I'm trying to create a form which will have 3 list boxes with 1st.Country, 2nd.State & 3rd.City. So when I first select the country list box, the state list should be populated with only the states of that country alone, then after choosing the state, the city list box should be populated with the cities in that state alone. I am trying to setup a form which would do this.

To solve this problem I would recommend looking into having the tables and the form in seperate files (You could keep them in seperates sheets or named ranges if you want).

Then connect to the table via AD0, pulling only the data you need when you need through SELECT statements and populate the listbox.

QB