>>Hi everybody,
>>
>>I have a 3 comboboxes on a form. When I select value in combo1, I want to update combos2 and 3 to show only relevant values. Same thing for combo3 which is dependent on combo2.
>>
>>My question is - how should I name the method(s) that would re-populate my combo2 and 3?
>>
>>Thanks in advance.
>
>The name isn't really important, is it? For that matter you don't need to call other methods. You could issue the requeries of combos 2 and 3 in the combo 1 LostFocus. Changing the value of combo 1 is what actually triggered the requeries, so it seems like an appropriate place to do it.
I want to do this in separate form's methods. BTW, I was calling this in InteractiveChange, but if that's the case I need some extra code to check if the value really has changed.
If it's not broken, fix it until it is.
My Blog