Unable to select a value from combo box

Hi Everybody,
I have an unbound combo box on an unbound form. The the default value for
the combo box is set using the On Load event of the form. When I open the
form in Form View, I cannot select any value from the drop down list other
than the default. However, it all works fine once I go to design view and
then back to form view. The property settings of the combo box are Enabled:
Yes; Locked: No. The Allow Edits property of the form is set to Yes. I do not
undestand what prevents me from selecting a value and why switching to Design
View and then back to Form View makes a difference. I thank you for your help
in advance.
Andras

Create another combo and set it up the same as the one that doesn't work.
If the second one works OK, just delete the one that won't work.
You should also try with a new form, as you may be seeing the beginning of
corruption in that form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"aeronaut" wrote in message
...
Hi Everybody,
I have an unbound combo box on an unbound form. The the default value for
the combo box is set using the On Load event of the form. When I open the
form in Form View, I cannot select any value from the drop down list other
than the default. However, it all works fine once I go to design view and
then back to form view. The property settings of the combo box are
Enabled:
Yes; Locked: No. The Allow Edits property of the form is set to Yes. I do
not
undestand what prevents me from selecting a value and why switching to
Design
View and then back to Form View makes a difference. I thank you for your
help
in advance.
Andras

Dear Jeanette,

I have tried both of your suggestions: the problem remained with a new combo
box in the original form, but when I copied the problematic combo box to a
new form it worked as it was supposed to. I take from what you said that my
original form must have been corrupted.
with thanks,
Andras

"Jeanette Cunningham" wrote:

Create another combo and set it up the same as the one that doesn't work.
If the second one works OK, just delete the one that won't work.
You should also try with a new form, as you may be seeing the beginning of
corruption in that form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"aeronaut" wrote in message
...
Hi Everybody,
I have an unbound combo box on an unbound form. The the default value for
the combo box is set using the On Load event of the form. When I open the
form in Form View, I cannot select any value from the drop down list other
than the default. However, it all works fine once I go to design view and
then back to form view. The property settings of the combo box are
Enabled:
Yes; Locked: No. The Allow Edits property of the form is set to Yes. I do
not
undestand what prevents me from selecting a value and why switching to
Design
View and then back to Form View makes a difference. I thank you for your
help
in advance.
Andras



.

From your description of the problem and the subsequent resolution, a corrupt
form is pretty sure to have been the culprit! Glad you got it fixed!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

By the way, forms do get corrupted during the development process.
Here is a link that explains about corruption during development
http://www.allenbrowne.com//ser-25.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"aeronaut" wrote in message
...
Dear Jeanette,

I have tried both of your suggestions: the problem remained with a new
combo
box in the original form, but when I copied the problematic combo box to a
new form it worked as it was supposed to. I take from what you said that
my
original form must have been corrupted.
with thanks,
Andras

"Jeanette Cunningham" wrote:

Create another combo and set it up the same as the one that doesn't
work.
If the second one works OK, just delete the one that won't work.
You should also try with a new form, as you may be seeing the beginning
of
corruption in that form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"aeronaut" wrote in message
...
Hi Everybody,
I have an unbound combo box on an unbound form. The the default value
for
the combo box is set using the On Load event of the form. When I open
the
form in Form View, I cannot select any value from the drop down list
other
than the default. However, it all works fine once I go to design view
and
then back to form view. The property settings of the combo box are
Enabled:
Yes; Locked: No. The Allow Edits property of the form is set to Yes. I
do
not
undestand what prevents me from selecting a value and why switching to
Design
View and then back to Form View makes a difference. I thank you for
your
help
in advance.
Andras



.