Combo Box Help

I have a combo box on a form that I want the content to be read only. If any
changes it should be done in the table. How can I accomplish this task? I
tried to set the locked property to true, it didn't work.

"Kissi Asiedu" <kissi5559@aol.comwrote in message
news:2Nudj.29349$C86.17027@fe18.usenetserver.com.. .Set Locked to True and Enabled to False.

Stuart McCall wrote:
That certainly will stop all changes on the combobox, to the point
there'd be no dropdown. But if I set a combobox locked status to Yes,
Enabled = Yes, even in verson A97, I can get the dropdown and scroll
thru the rosw I can't change the value.

I think Kissi's doing something wrong.

No Doctoring
http://www.youtube.com/watch?v=Ch4tSwP2_4M

"Salad" <oil@vinegar.comwrote in message
news:13ndfo0c5uren31@corp.supernews.com...I think you're right. Sometimes I answer far too quick. But heck I enjoyed
the youtube clip, so some good came of it :)

"Stuart McCall" <smccall@myunrealbox.comwrote in message
news:fl5ub6$2bk$1$8300dec7@news.demon.co.uk...Sorry Kissi. Please ignore that last post. As Salad says, it'll only make
matters worse. Locked = True certainly ought to do the trick.

Perhaps you need to be more specific. How are you setting the locked
property? In code? In a macro? In the property sheet in design view?

When you say it didn't work, what behaviour did you observe and what did you
expect to happen?

On Dec 29, 11:41 am, "Kissi Asiedu" <kissi5...@aol.comwrote:You could try that again.

Stuart McCall a écrit :Please excuse my bad English.
I believe he wants something like "limit to the list" (in French :
limiter à liste).

--
p-reine

On Sat, 29 Dec 2007 11:41:33 -0500, Kissi Asiedu wrote:
If you don't want someone to add to the list from the combo box, only
select from the list, then set the 'Limit to List' property of the combo
box to 'True.'

Thanks everyone, setting the Limit to List worked well for me.
"Don Calloway" <drcalloway@verizon.netwrote in message
news:b7Ddj.490$jX4.488@trnddc07...