Disabling values in a combo box....

[mattieflo]

Hello,

I have a continuous form that has a drop down box on it. I'm trying to give
a department visibility to the information on the form but give them access
to add certain values in the combo box. Is there a way I can accomplish this?

Thanks!

 

[Beetle]

Your subject line seems to indicate that you want to disable the combo box
but your post says that you want users to be able to add values to it, so I'm
not completely sure what you're trying to do, but if you want to add new
values to a combo box use the NotInList event. You will find info in your
Access help file or do a google search.

HTH

 

[mattieflo]

Hi Beetle....

I have two versions of the same database used by two different departments.
They are basically writing to the same tables. What I want is for both
departments to have visibility to each other's information but I don't want
them to be able to change the other departments info based on the selection
in the combo box. I'm not so sure I want them to be able to add items to the
combobox so much as I want each department to have access to select certain
values in the combobox. I thought about changing the row source for each
database version, but when I do that, they lose visibility of the value the
other department entered. I hope this makes some sense and if you think
there's a better way to accomplish this please feel free to let me know.

 

[Klatuu]

You can't enable or disable items in a combo. What you could do is add code
to the combo's After Update event to see which department the use is in and
determine whether they can use the selection. If they are not allowed to use
the selection, present a message box, then undo the combo box.

 

[mattieflo]

Oh great thought. I actually think that would work out better. Thanks I'll
give it a shot.