filtering combo box entries based on the selection of another combo box

[JulieD]

hi all

i have a form where the user can select "contract type" and based on their
selection we want the fields in another combo box "aircraft" to be filtered
based on this.

The aircraft combo box is based on a table that has aircraftid,
aircraftname, companyname and contracttype as fields.

However, the problem i'm having is two-fold
1) the values in contracttype are "A", "B", "C", "D", "E", but only some
aircraft have one of these types entered in the contract type box. What we
want is that if there is a match then only thoses aircraft are shown,
however, if a contracttype is select that has not been used in the aircraft
table then all records where no contracttype has been entered are to be
displayed.

2) then the aircraft combo box is to display a concatenation of companyname
and aircraftname (storing aircraftid in the underlying table)

not sure how to approach this.

Regards
Julie

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm