complex cascading combo boxes multiple criteria.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rpettis31 - 22 Apr 2008 06:04 GMT

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.

Reply to this Message

Al Campagna - 22 Apr 2008 13:10 GMT

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.

Signature

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."

>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.

Reply to this Message