Connecting Tech Pros Worldwide Help | Site Map

Combo Box Help

  #1  
Old December 29th, 2007, 04:45 PM
Kissi Asiedu
Guest
 
Posts: n/a
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.



  #2  
Old December 29th, 2007, 05:05 PM
Stuart McCall
Guest
 
Posts: n/a

re: Combo Box Help


"Kissi Asiedu" <kissi5559@aol.comwrote in message
news:2Nudj.29349$C86.17027@fe18.usenetserver.com.. .
Quote:
>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.
Set Locked to True and Enabled to False.


  #3  
Old December 29th, 2007, 09:45 PM
Salad
Guest
 
Posts: n/a

re: Combo Box Help


Stuart McCall wrote:
Quote:
"Kissi Asiedu" <kissi5559@aol.comwrote in message
news:2Nudj.29349$C86.17027@fe18.usenetserver.com.. .
>
Quote:
>>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.
>
>
Set Locked to True and Enabled to False.
>
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
  #4  
Old December 29th, 2007, 10:05 PM
Stuart McCall
Guest
 
Posts: n/a

re: Combo Box Help


"Salad" <oil@vinegar.comwrote in message
news:13ndfo0c5uren31@corp.supernews.com...
Quote:
Stuart McCall wrote:
>
Quote:
>"Kissi Asiedu" <kissi5559@aol.comwrote in message
>news:2Nudj.29349$C86.17027@fe18.usenetserver.com. ..
>>
Quote:
>>>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.
>>
>>
>Set Locked to True and Enabled to False.
>>
>
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
I think you're right. Sometimes I answer far too quick. But heck I enjoyed
the youtube clip, so some good came of it :)


  #5  
Old December 29th, 2007, 10:15 PM
Stuart McCall
Guest
 
Posts: n/a

re: Combo Box Help



"Stuart McCall" <smccall@myunrealbox.comwrote in message
news:fl5ub6$2bk$1$8300dec7@news.demon.co.uk...
Quote:
"Kissi Asiedu" <kissi5559@aol.comwrote in message
news:2Nudj.29349$C86.17027@fe18.usenetserver.com.. .
Quote:
>>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.
>
Set Locked to True and Enabled to False.
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?


  #6  
Old December 29th, 2007, 10:35 PM
lyle
Guest
 
Posts: n/a

re: Combo Box Help


On Dec 29, 11:41 am, "Kissi Asiedu" <kissi5...@aol.comwrote:
Quote:
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.
You could try that again.
  #7  
Old December 29th, 2007, 10:45 PM
p-reine
Guest
 
Posts: n/a

re: Combo Box Help


Stuart McCall a écrit :
Quote:
"Stuart McCall" <smccall@myunrealbox.comwrote in message
news:fl5ub6$2bk$1$8300dec7@news.demon.co.uk...
Quote:
>"Kissi Asiedu" <kissi5559@aol.comwrote in message
>news:2Nudj.29349$C86.17027@fe18.usenetserver.com. ..
Quote:
>>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.
>Set Locked to True and Enabled to False.
>
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?
>
>
Please excuse my bad English.
I believe he wants something like "limit to the list" (in French :
limiter à liste).

--
p-reine
  #8  
Old December 30th, 2007, 02:15 AM
Don Calloway
Guest
 
Posts: n/a

re: Combo Box Help


On Sat, 29 Dec 2007 11:41:33 -0500, Kissi Asiedu wrote:
Quote:
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.
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.'
  #9  
Old December 30th, 2007, 06:05 PM
Kissi Asiedu
Guest
 
Posts: n/a

re: Combo Box Help


Thanks everyone, setting the Limit to List worked well for me.
"Don Calloway" <drcalloway@verizon.netwrote in message
news:b7Ddj.490$jX4.488@trnddc07...
Quote:
On Sat, 29 Dec 2007 11:41:33 -0500, Kissi Asiedu wrote:
>
Quote:
>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.
>
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.'


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to multi select items in a combo box(help Me) Tuku answers 1 May 18th, 2007 01:15 AM
Dependant Combo Box HELP StevoGman answers 12 September 21st, 2006 09:17 AM
Access 2003 Beginner - Requery from Combo Box Help jay answers 2 May 12th, 2006 04:55 AM
Combo Box Help Matt answers 1 November 20th, 2005 02:19 PM
combo box help Oktom Ben answers 0 July 19th, 2005 04:20 PM