Combobox control

[Beany]

Hi,

Ive got a form which has three Comboboxes, 1) User, 2) Department and 3) Site....

Underneath the comboboxes i have a subform which displays records if i select a user, department or a site..

What i want to know is, if i select one combobox, how do i dim out the other two comboboxes? so if i choose a user from the user combobox, how can i shade away the department and site comboboxes?

all help will be appreciated ..


thanks

[Stwange]

Hi,

Ive got a form which has three Comboboxes, 1) User, 2) Department and 3) Site....

Underneath the comboboxes i have a subform which displays records if i select a user, department or a site..

What i want to know is, if i select one combobox, how do i dim out the other two comboboxes? so if i choose a user from the user combobox, how can i shade away the department and site comboboxes?

all help will be appreciated ..


thanks

Look at the after_update() property, and use the following code for each of the other combo-boxes:
comboWhatever.enabled = False

[Beany]

Look at the after_update() property, and use the following code for each of the other combo-boxes:
comboWhatever.enabled = False

thank you for your reply,

for my comboboxes ive already got some data in the after_update event, for example one of the combos has:

Private Sub Combo2_AfterUpdate()
    blnUser = True
    FilterSubForm
 
  Me.Combo2.Requery
 
End Sub

where would i insert

comboWhatever.enabled = False

??

thanks

[Beany]

any1? im kinda stuck.....

thanks peeps

[Beany]

If the combobox after_update event is occupied with other code,

where would i insert

comboWhatever.enabled = False

?

[MMcCarthy]

Using this example and assuming the other two combo boxes are 1 and 3 ....

Private Sub Combo2_AfterUpdate()
 
    Me.Combo1.Enabled = False
    Me.Combo3.Enabled = False
 
    blnUser = True
    FilterSubForm
 
    Me.Combo2.Requery
 
End Sub
 

Beany it would help the experts if in future you experimented a little with the advice you are given to see for yourself how it works. Then if you don't get the behaviour you expect you can tell the experts what you have tried. If the experts can't see that you are trying to figure it out for yourself they will be discouraged from helping you.

Mary