>>It seems to work OK the way I re-coded except for this problem I had before and have now :(
>>
>>See attached - when I select something, everything goes blank - do you know a solution here?
>>
>>BTW, don't be surprised about the test data - I let my older son test this form and he found a lot of bugs.
>
>Put:
>
>this.Value = this.Value
>
>in InteractiveChange event of the combo.
>
>P.S. I see he is a big fan of English football :-)
He is a soccer's fan in general, knows all English teams as well as Russian teams. He edits Wikipedia pages about soccer all the time (pages about some exotic Russian teams nobody cares about).
Anyway, this is what I already had in cboLevel and I'm adding this last line right now
this.Value = this.Value
PRIVATE nLevelID
nLevelID = this.Value
this.Parent.Parent.Refresh()
UPDATE. It didn't help, so I'll try removing this code completely.
If it's not broken, fix it until it is.
My Blog