3 Comboboxes

[Beany]

Hi,

How can i hide or disable one combobox when another combobox is selected?

All help will be appreciated

thanks

[damonreid]

You can just do an if loop or a case select on each of the combo boxes to disable the other ones when selected on the first.

me.comboboxnumber.enabled = false

[Beany]

You can just do an if loop or a case select on each of the combo boxes to disable the other ones when selected on the first.

me.comboboxnumber.enabled = false

ok thats brill..but how would i enable them by clicking on them?

[damonreid]

If you want to be able to change it perhaps you should change the locked status and not the enable status? If this is what you want to do then.

Else try this.

me.comboboxname.enable = true

[Beany]

If you want to be able to change it perhaps you should change the locked status and not the enable status? If this is what you want to do then.

Else try this.

me.comboboxname.enable = true

sorry but i dont understand, ive got three comboboxes, Combo2, Combo4 and Combo6.

Ive put the following in Combo2:

Private Sub Combo2_AfterUpdate()
    blnUser = True
    FilterSubForm
 
    Me!Text18.ControlSource = "[ID]"
 
  Me.Combo4.Enabled = True
  Me.Combo6.Enabled = True
    Me.Combo2.Requery
End Sub

But its not doing anything? am i doing something obviously wrong?

[damonreid]

Do you want them to only use one combo box?
If so change the ".enabled = true" to ".enabled = false" for the other two combo boxes.

[Beany]

Do you want them to only use one combo box?
If so change the ".enabled = true" to ".enabled = false" for the other two combo boxes.

okay but then i cant click on the other two... it disables them...


What i want is: The user can only select from one combobox but if he wants to select from another, he just puts the cursor over it and it enables...

i was told this wasnt possible? is that true?

[damonreid]

I am not sure what the point is in disabling them, why not just leave the fields open?

You could add an "After Update" event on each of the fields to clear the values in the other two if you want?

[Beany]

I am not sure what the point is in disabling them, why not just leave the fields open?

You could add an "After Update" event on each of the fields to clear the values in the other two if you want?

Ok, thats a good idea, becoz the comboboxes dont clear...

what would i put in the after update event for it to clear?

thanks so far bud

[damonreid]

Try this

me.comboxboxname.value = ""

[Beany]

Try this

me.comboxboxname.value = ""

thanks damon! for all the help

[damonreid]

No problem, glad I could help.