List of Choices

[lios1984]

Hello to everyone,

I want to make a table where there will be two fields, among others: Country and City.

The value of Country will come from a List of Choices but the value of City will come from a similar list of the cities only in the chosen country.

For example, I choose from the list England as Country. In the field City the list of choices will be only cities in England.



How can I do that??


Help please!!

[pbaldy]

Cascading combos:

Baldy-Cascading Combos

[lios1984]

It can be done only with Visual Basic??

I don't really know Visual Basic, I've only worked with C.
Moreover, your suggestion refers to forms. Can't I do that for tables?

[pbaldy]

I don't know of a good developer that lets users work directly in tables. To my knowledge there's no way to do it in a table anyway.

The Requery method could be done with a macro, if you prefer.

[ssanfu]

It can be done only with Visual Basic??

I don't really know Visual Basic, I've only worked with C.
Moreover, your suggestion refers to forms. Can't I do that for tables?

If you are referring to lookup fields at the table level, I don't think you can do what you want.

Read: "The Evils of Lookup Fields" at http://access.mvps.org/access/lookupfields.htm

I never allow data entry, edits, adds from a table. Well, if I am the only one using the database for something quick and dirty......

Forms & VBA give you more control and abilities..... if you plan to use Access a lot, you need to learn how to program. Its not that hard.. lots of free resources on the web to teach you how to program....