Mik Mak
asked on
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 ?
Rey Obrero (Capricorn1)
check the forms Allow Edits property, set it toYes
ASKER
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
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
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?
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?
The combobox 'Enabled' property should be set to Yes and 'Locked' property set to No.
Check if there are any event procedures (e.g. On Click / Before Update / After Update) for the combobox that might be preventing the change.
ASKER
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
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
ASKER
No event procedures are related to any of the controlboxes - only the form Open and form Close
<but that'll be later today, as the form is a bit complex. >
just try it with few controls ...
just try it with few controls ...
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?
http://rdsrc.us/RcduMw
What is the row source and row source type?
ASKER
Its evening here - need to feed the kids, and will return a bit later :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm glad you got it sorted. Thanks for the points ;-)
ASKER
No problem - still can't figure out the logic in that problem, though :)
ASKER
Thank you for the speedy response