I have cascading combo boxes and I currently have the row source in my 2nd combo box as... [Forms]![frmPurchaseOrder]![Vendor]
I need some sort of Iif statement that says...
Iif Vendor=7, *show all inventory ID's*, [Forms]![frmPurchaseOrder]![Vendor]
basically, how do you get the statement in there to "show all"?