dbTalk Databases Forums  

Combo Box not working in Access 2007

comp.databases.ms-access comp.databases.ms-access


Discuss Combo Box not working in Access 2007 in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ken
 
Posts: n/a

Default Combo Box not working in Access 2007 - 08-10-2010 , 07:45 AM






I am using a combo box that has a control source of a text field of
size 50. I also am using a value list with "val1", "Val2", "val3"
values for example.

Anyhow in access 2007 when I click on the value of the combo box
nothing happens. In 2003 what I click on becomes the value of the
combo box, anotherwords I'm able to update the control source.

Any ideas?

Reply With Quote
  #2  
Old   
Salad
 
Posts: n/a

Default Re: Combo Box not working in Access 2007 - 08-10-2010 , 10:41 AM






Ken wrote:

Quote:
I am using a combo box that has a control source of a text field of
size 50. I also am using a value list with "val1", "Val2", "val3"
values for example.

Anyhow in access 2007 when I click on the value of the combo box
nothing happens. In 2003 what I click on becomes the value of the
combo box, anotherwords I'm able to update the control source.

Any ideas?
On your 2007 development copy, what happens if you drop a new combo box
on it and follow the wizard for a value list, save, and run? If the new
combo works, delete the old combo, rename the new combo to the old name,
and make sure an events for the old are associated with the new.

Reply With Quote
  #3  
Old   
Ken
 
Posts: n/a

Default Re: Combo Box not working in Access 2007 - 08-10-2010 , 12:02 PM



On Aug 10, 11:41*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
Quote:
Ken wrote:
I am using a combo box that has a control source of a text field of
size 50. I also am using a value list with "val1", "Val2", "val3"
values for example.

Anyhow in access 2007 when I click on the value of the combo box
nothing happens. In 2003 what I click on becomes the value of the
combo box, anotherwords I'm able to update the control source.

Any ideas?

On your 2007 development copy, what happens if you drop a new combo box
on it and follow the wizard for a value list, save, and run? *If the new
combo works, delete the old combo, rename the new combo to the old name,
and make sure an events for the old are associated with the new.
No that did not help. I still click on the list that comes up and I am
unable to select anything from the list...

Reply With Quote
  #4  
Old   
christianlott1@yahoo.com
 
Posts: n/a

Default Re: Combo Box not working in Access 2007 - 08-10-2010 , 02:51 PM



On Aug 10, 12:02*pm, Ken <gev... (AT) gmail (DOT) com> wrote:
Quote:
No that did not help. I still click on the list that comes up and I am
unable to select anything from the list...
Check the allow edits, additions, deletions properties. Check the
enabled and locked properties.

I checked it in a new db on a new form in 2007. Combo box works fine
here. I used the wizard.

(Now getting Word 2007 mail merge to work is another story )

Reply With Quote
  #5  
Old   
Douglas J. Steele
 
Posts: n/a

Default Re: Combo Box not working in Access 2007 - 08-10-2010 , 07:50 PM



Is your database located in a trusted location, or have you enabled it so
that code will run?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by Wiley
(no e-mails, please!)



"Ken" <gevayl (AT) gmail (DOT) com> wrote

Quote:
I am using a combo box that has a control source of a text field of
size 50. I also am using a value list with "val1", "Val2", "val3"
values for example.

Anyhow in access 2007 when I click on the value of the combo box
nothing happens. In 2003 what I click on becomes the value of the
combo box, anotherwords I'm able to update the control source.

Any ideas?

Reply With Quote
  #6  
Old   
Ken
 
Posts: n/a

Default Re: Combo Box not working in Access 2007 - 08-11-2010 , 09:42 AM



On Aug 10, 3:51*pm, "christianlo... (AT) yahoo (DOT) com"
<christianlo... (AT) yahoo (DOT) com> wrote:
Quote:
On Aug 10, 12:02*pm, Ken <gev... (AT) gmail (DOT) com> wrote:



No that did not help. I still click on the list that comes up and I am
unable to select anything from the list...

Check the allow edits, additions, deletions properties. Check the
enabled and locked properties.

I checked it in a new db on a new form in 2007. Combo box works fine
here. I used the wizard.

(Now getting Word 2007 mail merge to work is another story )
Everything is enabled and not locked...

Reply With Quote
  #7  
Old   
Salad
 
Posts: n/a

Default Re: Combo Box not working in Access 2007 - 08-11-2010 , 10:45 AM



Ken wrote:

Quote:
On Aug 10, 3:51 pm, "christianlo... (AT) yahoo (DOT) com"
christianlo... (AT) yahoo (DOT) com> wrote:

On Aug 10, 12:02 pm, Ken <gev... (AT) gmail (DOT) com> wrote:




No that did not help. I still click on the list that comes up and I am
unable to select anything from the list...

Check the allow edits, additions, deletions properties. Check the
enabled and locked properties.

I checked it in a new db on a new form in 2007. Combo box works fine
here. I used the wizard.

(Now getting Word 2007 mail merge to work is another story )


Everything is enabled and not locked...
What happens if you were to create a brand new TEST form using a TEST
backend and created a brand new form with 2-3 fields for testing?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.