Combo Box Question

[Gman063 via AccessMonster.com]

I have a Table with following fields; Fiscal Year, Doc Number, performer, and
APPN.
Table has numerous entries with duplicates in all fields.

On my form I have Combo Boxes for each field, that has a record source based
on a
Select Distinct query, that filters a List Box.

The question is:
Is there a way to filter the other Combo Boxes based on the selection from
one
Combo Box (i.e. If I select "Company 1" from combo box Performer, the other
combo boxes will
show only the information from the table that match Company1 and so on)?

 

[Guest]

Yes. Add a Where Clause to the query for the row source of the combos you
want to filter by performer:
WHERE [performer] = '" & Me.cboPerformer & "'"
Then in the after update event of the performer combo, requery the combos
you want filtered.

 

[Allen Browne]

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