Combo Box value list acting like it's locked.

  • Thread starter Thread starter John Keith
  • Start date Start date
J

John Keith

The combo box is in the header section.

Control Source: (is blank)
Row Source Type: Value List
Row Source: "Option 1";"Option 2";""
Locked: No

The dropdown shows the Row Source, but when selecting one of the options...
nothing happens.. just like what happens when a field is locked. I.E. the
mouse hovering over highlites the choice, but clicking it wil not select it
(the dropdown list remains open).

What is causing this? Other options to double check?

My intention is to use the value of this control box inside the AfterUpdate
event to run a SQL update that will change multiple rows that match the
selected key.
 
Found It!

Allow Edits: No
(didn't think that this would effect controls that did not have a "control
source") Any field that I don't want the user to change, I lock.
 
Back
Top