complex cascading combo boxes multiple criteria.

[Rpettis31]

I have a combo box that lists an item type such as Frame.
The second combo box lists the issue category such as cosmetic
Based on these two critera I would like the issue type pull from the
FrameCosmetic table list.

 

[Al Campagna]

Rpettis31,
In your IssueType combo (ex. cboIssueType) you can use the values from
the two previous combos to filter the cboIssueType records delivered, by the
cboIssueType RowSource query.
In cboIssueType, your ItemType field would have a criteria of (example)
=Forms!frmYourFormName!cboIssueType
and
=Forms!frmYourFormName!cboIssueCategory
as the criteria for the IssueCategory.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."