Creating Combo boxes based on Criteria

[Chuck]

I'm trying to create a form that has 3 combo boxes that the user needs to
select before they can create a report.

I'd like for the selections available within the second combo box to be
contingent on the criterea the user selects in the first combo box. Same for
the third combo box to be contigent on the criterea selected in the second.

Does anyone know any VBA or other method that would allow this?

 

[Golfinray]

What you need are cascading combo box filters. Martin Green at
www.fontstuff.com and Allen Browne at www.allenbrowne.com both have excellent
examples of how to build those.