Locked combobox

I've added an unbound combobox to a popup/modal form - but strangely I'm unable to select any of the values in the dropdown. I've tried to restore the form from an old backup, and add the combobox again, but without any luck. Any ideas ?
LVL 1
Mik MakConsultantAsked:
Who is Participating?
 
Mik MakConsultantAuthor Commented:
Hmm, finished dinner early - the function calling/openening the form  had a IsLoaded check to see if the for was still open - and that apparently messed up the comboboxes - as soon as I removed the IsLoaded loop everything worked perfectly... go figure :)

Thank you for all your speedy responses.
0
 
Rey Obrero (Capricorn1)Commented:
check the forms Allow Edits property, set it toYes
0
 
Mik MakConsultantAuthor Commented:
Unfortunately it isn't that easy :)

AllowEdits— Yes
AllowDeletions— Yes
AllowAdditions— Yes
DataEntry— No

The form has got some other textboxes and tick/selectbox, that are also unbound that behaves fine - it's only the comboboxes weirdly
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Rey Obrero (Capricorn1)Commented:
first do a compact and repair.

test again the combo box..

if problem insists,
can you try creating a new form, add a combo box and check its behaviour..

what version of access are you using?
0
 
Oliver WastellMemberCommented:
The combobox 'Enabled' property should be set to Yes and 'Locked' property set to No.
0
 
Oliver WastellMemberCommented:
Check if there are any event procedures (e.g. On Click / Before Update / After Update) for the combobox that might be preventing the change.
0
 
Mik MakConsultantAuthor Commented:
Enabled is set to Yes, and Locked to No

Compact & repair tried, with no change. I can try and create a new form, but that'll be later today, as the form is a bit complex.

It's version 2003 - but same problem occurs on Access 2010 64bit
0
 
Mik MakConsultantAuthor Commented:
No event procedures are related to  any of the controlboxes - only the form Open and form Close
0
 
Rey Obrero (Capricorn1)Commented:
<but that'll be later today, as the form is a bit complex. >

just try it with few controls ...
0
 
Oliver WastellMemberCommented:
Another expert exchange user had what looks to be a similar problem:
http://rdsrc.us/RcduMw
What is the row source and row source type?
0
 
Mik MakConsultantAuthor Commented:
Its evening here - need to feed the kids, and will return a bit later :)
0
 
Oliver WastellMemberCommented:
Ditto -you'll probably be back in the office same time as me then!
0
 
Rey Obrero (Capricorn1)Commented:
also, check if you have duplicate values listed in the combo box bound field.
0
 
Oliver WastellMemberCommented:
I'm glad you got it sorted. Thanks for the points ;-)
0
 
Mik MakConsultantAuthor Commented:
No problem - still can't figure out the logic in that problem, though :)
0
 
Mik MakConsultantAuthor Commented:
Thank you for the speedy response
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.