How can you make a combo list unclickable?

[netchie]

Hi,



I have description list (desc) where if you chose certain description (mild, medium, severe) the next combo field beside it (level) will auto populate a number (e.g. 1,2,3,4,5). The thing is, some users are getting used of forcedly changing the level if they feel like it. Let's say if they choose mild from Desc list, the level field should auto-populate to "1" but most of the time users changed this level to different number from the list because it's clickable.

Is it possible to make it unclickable as soon as it auto-populate the right level from the list? Can you please let me know how to do this?

Thanks in advance,
netchie

[boblarson]

You can lock it using

Me.ComboNameHere.Locked = True


but why even have a combo if it is not supposed to be used?

[June7]

Why are you using a combobox if users should not have a choice? Maybe you need to limit user choices by filtering the combobox based on choice in first combobox (cascading or dependent comboboxes).

As far as I know, can't make non-clickable. You could disable the combobox based on choice in first combobox.

[netchie]

Well, basically we're looking for a specific level. A group will check them if it can be changed to lower level. The thing is, the users already deciding to change it by themselves before data can reach the group who are checking those level. To make it short, there is a group who will decide if the level can be changed to different level but the users are trying to mess it up lol.

@boblarson - where should I put that? When I clicked the Event Procedure for Level, there is already an existing "Private Sub" whatever inside. Should I create a new "Private Sub" for it and put the command you gave me?

[boblarson]

Put it in the AFTER UPDATE event of the first combo box. And no, you don't create a new Private Sub - you just put it between the existing:

Private Sub Form_AfterUpdate()
   Me.YourSecondComboBoxNameHere.Locked = True
End Sub

But actually, given your situation, why not just lock it in design view and then have a password protected button to unlock it for those who are supposed to review it so they can change it if necessary.

[netchie]

This is what I put in After Update - Event Procedure:

Private Sub cbLevel_AfterUpdate()
Me.cbPriority.Value.Locked = True
End Sub

...it didn' work

I also tried this:

Private Sub cbLevel_AfterUpdate()
Me.cbPriority.Locked = True
End Sub

...same result

cbLevel auto-populate based from what the user chose from the Desc list. cbLevel needs to be unclickable/grayish as soon as it auto-populate.

Sorry for being pain in the butt

[boblarson]

Did you try clicking on it to see if it could be clicked on? (the second one was the correct one, by the way).

If you want it grayed out, then change .Locked to .Enabled and change True to False:

Me.cbPriority.Enabled = False

[netchie]

@boblarson - nevermind. I put it in a wrong field that's why. I corrected it and IT WORKED! Wooo Hooo!!

Thanks boblarson and June 7 for checking this for me.

netchie

[June7]

I would set the combobox as disabled in Properties then use code to enable it when appropriate. You can still use code to autopopulate. This way, it will never be available to users. They can't accidentally enter value in that combobox and overlook the first one.

Possibly don't need password control. If you have a way to distinguish between user/group then can enable controls as appropriate when form opens. Should group be allowed to change first combobox value?

[netchie]

Got it! Thanks again June7