Problem with combo box

[Rupa]

Hey all

I have a combo box that picks up contact names from a field of a table. So it's basically:

Select ContactName
FROM tbl_clients

The problem is that it won't let me type in it. As soon as I hit any letter, it display the name that begins with that letter and then highlights the previous field which is date. So for example, if I want to look for Abc, I type A, and before I can type b, it highlights the previous filed.

Any response will be highly appreciated.

Many thanks,

Rupa

 

[boblarson]

1. Do you have any code set for the combo box or the form?

2. Do you have a timer running on the form?

 

[Rupa]

Thanks for your response. I have got an 'on change' event that requeries a subform but nothing else.

No timer either.

Any ideas?

Regards,

Rupa

 

[Rupa]

I tried something, without the requery, it lets me type in the combo box but doesn't otherwise. I have a same type of combo box on another form which lets me type in but this one doesn't when it has the same 'on change' event.

Thanks,

Rupa

 

[Rupa]

I have just created a new form and it works! Thanks for your help anyway

Regards,

Rupa