[X]My Assistant

[samersy]

hello
i have many comboxes , so I want if i choose the first item in main combox the other comboxes show the first item's and so on , if i choose the second item then the other comboxes show the second ..
i made this code but for one combox it is very long , is there any short code for this :
Me.h5.SetFocus
Me.h5.Dropdown
If Me.h5.Selected(0) = True Then
Me.h4.SetFocus
Me.h4.Dropdown
Me.h4.Selected(0) = True
Me.h4.Selected(1) = False
Me.h4.Selected(2) = False
Me.stduent.SetFocus
Else
Me.h5.SetFocus
Me.h5.Dropdown
If Me.h5.Selected(1) = True Then
Me.h4.SetFocus
Me.h4.Dropdown
Me.h4.Selected(0) = False
Me.h4.Selected(2) = False
Me.h4.Selected(1) = True
Me.stduent.SetFocus
Else
Me.h5.SetFocus
Me.h5.Dropdown
If Me.h5.Selected(2) = True Then
Me.h4.SetFocus
Me.h4.Dropdown
Me.h4.Selected(0) = False
Me.h4.Selected(1) = False
Me.h4.Selected(2) = True
Me.stduent.SetFocus

[tina t]

if i choose the first item in main combox the other comboxes show the first item's and so on , if i choose the second item then the other comboxes show the second

not sure what you mean by the above, can you explain more fully, pls? remember we can't see your db and don't know anything about it except what you tell us.

also, don't really understand the multiple "Selected(x)" in your code. AFAIK, a combobox can't have multiple items selected at one time. the .Value property of a combobox control holds the value in the bound column of the selected "item" from the droplist. are you actually working with a listbox control, rather than a combobox control?

hth
tina
This post has been edited by tina t: Oct 11 2019, 07:46 PM

[arnelgp]

simply put:

CODE

With Me.h4
     .SetFocus
     .DropDown
     .Value = .ItemData(Me.h5.ListIndex)
End With