clear a combo box with a macro

[Nikki]

I'm using a 2 combo boxes to set the visible property of 2 associated
subforms. When the user enters information into one combo box, I want to
clear out the data for the other combo box. I am not at all familiar with VBA
but I tried to use a macro on the AfterUpdate of the first combo box to
SetValue of combo box 2 to Null when combo box 1 is updated. At first I
thought it was working but when I tried to open the form fresh I get an error
about the control I'm trying to set to null is not a Variant. Can someone
help me?!? The combo boxes are based on Table/Query source data, but that's
what I thought most Combo boxes were based on.

 

[NetworkTrade]

the combobox is looking up values query style....while it might be possible
to force it to return a null value - - it would be easier for you to make it
not visible....you might consider this approach instead....