enabled/disabled control continuous form

[mcnews]

i need to enable or disable a combobox based on another value on a
continuous form. the on current event works if the particular value
is the same for all rows, but it will not always be the same.

tia,
mcnewsxp

 

[Douglas J. Steele]

Doesn't really matter whether it's being set the same way for each row. Just
put the logic that enables or disables into the form's Current event. Yes,
it'll show as being enabled for every single row, but if you try working
with a combo box that shouldn't have been enabled, you'll have to change the
current row first, and Access will then disable the combo box when that
happens.

 

[mcnews]

That's true, Doug, but it's disconcerting to some users to see all the
comboboxes
constantly changing from enabled to disabled. I've actually been consulted
twice to "fix" an app someone else wrote because of this very thing!

Locking the combobox instead of disabling it would, of course, do the same
thing without having the controls constantly going from normal to grayed out
to normal again.

yes, i was using the on current, but the POC for this app asked that i
*fix* it. the conditional formating does the trick, but things look a
little weird as you scroll down through the form. but once the screen
settles it looks as expected.
BTW - what would locking do?

 

[Douglas J. Steele]

If the combo box was locked, it would look normal, but the user wouldn't be
able to select anything from it. (They would be able to scroll through it to
see what possible values there were)