Overturn My combo box!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 combo box
namely [products] and
Code: 
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
 
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]
[/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
Click to expand...
 
Back
Top