Overturn My combo box!!!

[Guest]

I have 2 combo box
namely [products] and

when i change [code], the [products] also change but the is only one
selection in the [products] combo box

so how to make the [products] to change itself automatically to first
selection from the list when i change the [code]

Any solution?

Thanks in advance

Kennykee

 

[Tim Ferguson]

when i change

, the [products] also change but the is only one
selection in the [products] combo box

so how to make the [products] to change itself automatically to first
selection from the list when i change the [code]
[/QUOTE]
I am guessing that what you want to do is change the RowSource of the
second combo box when the user makes a selection in the first one. If that
is correct, then you can use the AfterUpdate event of the first box to
create some appropriate SQL for the second box and then to call the second
box's .Requery method.

For explicit code, try googling for "cascading combo boxes".

Hope that helps



Tim F