Lookup Values

[gjw1012]

Hi,
I am relatively new to Access, and use 2007 version. Can anyone help me solve a problem?
I want to create 2 or 3 lookup lists, where the value selected in List 1 determines the values available to be selected in List2, and similar for List 3. Eg: If list 1 contains Countries, and Country AA is selcted, List 2 shows only Cities for Country AA, (say City ZZ) and List3 contains only Districts in City ZZ (say District ZZ12). Its the type of list selection which airlines use to restrict available destinations for particular departure airports.
Any help appreciaited, thanks.

[RuralGuy]

It is called Cascading Lists or ComboBoxes and this link should help.

[gjw1012]

Thanks to RuralGuy for help with my request. I have managed to add the code for cascading combo boxes to my form, but now cannot make a connection with the table so that, although the form shows the selections I make, the table is not updated to store the values. Any suggestions very welcome.

Many thanks.

gjw

[RuralGuy]

You're not using Lookup Fields are you?

[gjw1012]

Thanks for your very prompt response to my post. I have 2 tables (Categories & Products) and have used the code you suggested on the form. It has created a relationship, which allows the two combo boxes on the form to work well. Each category selected in Combo Box 1, returns all the correct values in Combo Box 2. A great success, thanks. I thought at that point I had cracked it with your assistance, only to discover later that the values selected do not get posted to the table from which I created the form. I subsequently amended the Combo Box 1 "Row Source" to "Categories" and this now adds the data to the Main Table, OK. However the Combo Box 2 resolutely refuses to do the same when its "Row source" is amended to "Products". Instead it loses the Products and then shows the Product ID.
Any help much appreciated.

Thanks

gjw

[RuralGuy]

Maybe if you posted a sample of your db so we could look at it. Remove any sensitive data of course.