I have an after-update event procedure for a combo box that populates a second combo box with the following:
Private Sub CategoryID_AfterUpdate()
ProcuctID = PruductID.ItemData(0)
The problem is that if a category is selected in which there are no products, I get a Run-time error '3162' saying that I tried to assign a null valuable to a variable that isn't a variant data type.
How can I get around this?