Gray out combo box base on value list (1 Viewer)

ivonsurf123 · May 14, 2018

Hello,

I just can't figure out how to grey out the combobox when value chosen is "closed". combobox is set to have a value list in the resource type and the resource is "Open", "Closed"

Code:

If Me.[Position_Status] = "Closed" Then
    Me.[Position_Status].Enabled = False
  Else
    Me.[Position_Status].Enabled = True
End If

isladogs · May 14, 2018

The code will work provided the 'Closed' value is the bound field (normally hidden)in your combobox (Position_Status)
If that is a value in the 2nd visible column, then do one of the following:
a) change the code to reference the corresponding value in the hidden bound (ID?) field
b) change the first line to:

Code:

If Me.[Position_Status].Column(1) = "Closed" Then

ivonsurf123 · May 14, 2018

Thank you Ridders, but did not work...The one I submitted does it, but it does not stay gray out, it just flash it and go back to showing the field with value enable again when I change to another record

Code:

If Me.[Position_Status].Column(1) = "Closed" Then
    Me.[Position_Status].Enabled = False
  Else
    Me.[Position_Status].Enabled = True
End If

Beetle · May 14, 2018

Is this a continuous (aka multiple items) form? if so this is not going to behave like you're expecting. A continuous form is really just one set of Controls that is repeated for each row of data in the record source. Any code like this that you use to manipulate the behavior of a given Control based on the current row is going to be applied to the instance of that Control for all rows. You might be able to use Conditional Formatting, in which case you might need two rules;

Expression Is [Position Status] = "Open" (leave the Enabled property on)
Expression Is [Position Status] = "Closed" (turn the Enabled property off)

isladogs · May 14, 2018

Which event is your code used in?

missinglinq · May 15, 2018

ridders said:
Which event is your code used in?

This is really important! Are you getting an error message? If you're trying to Disable the Combobox using one of its events, such as its AfterUpdate event, it won't work, because you cannot Disable a Control while it has Focus.

You wouldn't really want to Disable it while making your original selection from it...what would happen if the user made a mistake, or changed their mind...they couldn't correct it.

For the Enable/Disable property to be Record-appropriate, your code would need to be in the Form_Current event.

Linq ;0)>

ivonsurf123 · May 15, 2018

No I am not receiving an error message, I am using it in the current event. but is not behaving well, It is a continuous form. Thank you for helping.

missinglinq · May 15, 2018

With a Continuous View Form (or a Datasheet View Form) you have to use Conditional Formatting, as Beetle suggested:

In Form Design View:

Right-Click on the Combobox
Click on Conditional Formatting
Under 'Condition1' select Expression Is
In the next box, enter [Position Status] = "Closed"
Now click on the 'Enabled' icon...the one on the far right (to turn the Enabled property off)
Now click on OK

Now you're done!

Linq ;0)>

ivonsurf123 · May 15, 2018

OMG! Thank you so much missinglinq! finally worked.

missinglinq · May 15, 2018

Glad we could help!

Good luck with your project!

Linq ;0)>

Gray out combo box base on value list (1 Viewer)

ivonsurf123

Registered User.

isladogs

MVP / VIP

ivonsurf123

Registered User.

Beetle

Duly Registered Boozer

isladogs

MVP / VIP

missinglinq

AWF VIP

ivonsurf123

Registered User.

missinglinq

AWF VIP

ivonsurf123

Registered User.

missinglinq

AWF VIP

Similar threads

Users who are viewing this thread