Combo Box value list acting like it's locked.

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.
 
J

John Keith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top