Combo Box won't select

[lizm100]

I have a problem with a combo box on a form. The user should be able to select a value from the drop down, this value is then used as criteria to fill in the other fields on the form.
My problem is that sometimes it works correctly and sometimes the Combo Box will not allow me to select a value, i can click on the combo box arrow, view the selection criteria, but upon mouse clicking a value, it highlights the value but doesn't select it and the drop down remains displayed.
Does anyone have any ideas on what's causing this???

 

[KingKong]

Have you tried to requery the combobox?

 

[Zippyfrog]

Is that combo box bound to something? Because sometimes when I set up a combo box for the first time, it lists all the choices in the combo box, but when I choose the value, it won't allow that value to be chosen because it is bound to another field.

 

[lizm100]

Yep, I requery it and it's unbound.

Any other ideas anyone - please???

 

[KingKong]

Have you looked at the properties of the cbo, to make sure that it's not locked?

 

[lizm100]

Yes, done that too!
It's not locked or disabled.
It was working and it's now given up on me and (honestly) i didn't change anything.
I can't enter text or select from the drop down.
I can do that with another combo on the form which is set up exactly the same apart from the information it's populated with.

 

[KingKong]

???

I'm a bit puzzeled, perhaps you could post your db so I can take a look at it?

Grtz,

Peter.

PS. I'm using Access97