Need a field's choosable options to depend on the data in another

[harryedwards]

I'm designing a form with drop-down list boxes. So let's say I have a field
called 'species' and another called 'sub-species'. If the record's entry in
the 'species' field is 'dog', the user should only be able to choose
'labrador', 'dalmatian', 'dachshund', etc from their drop-down list when
making the corresponding entry in the 'sub-species' field. If the 'species'
entry is 'bear' the user should only be able to choose 'grizzly', 'panda',
'polar bear', etc as a sub-species.

Hope that makes sense! I presume the Expression Builder is probably the way
to do this, but I haven't used it before, so if someone could talk me through
it I'd be grateful.

Thanks.

 

[Wayne-I-M]

Hi

If you search this forum for "casscading combo boxes" you will find many
answer to this.

 

[Van T. Dinh]

See The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm