combo box - disable dropdown

I have a combo box on a form that is filled with lookup values (integers)
from another table. I have "Limit to List" set to "Yes". The user is able
to type in a number. If that number is in the list, it is selected. If the
number that is typed in is not in the list, a message pops up that says so.
This is exactly what I want, but...

I would prefer not to allow the user to drop the list down to browse the
numbers that are in the list. Basically, I think I just want to disable the
dropdown functionality of the combo box. I would like it to look just like a
text box, except that it would only allow you to enter certain values (key
values that come from another table).

Can anyone tell me if there is a way to do this?

Thanks,
Paul
--
Paul Kraemer

Set the List Rows property of the combo box to 1.

"Paul Kraemer" wrote:

I have a combo box on a form that is filled with lookup values (integers)
from another table. I have "Limit to List" set to "Yes". The user is able
to type in a number. If that number is in the list, it is selected. If the
number that is typed in is not in the list, a message pops up that says so.
This is exactly what I want, but...

I would prefer not to allow the user to drop the list down to browse the
numbers that are in the list. Basically, I think I just want to disable the
dropdown functionality of the combo box. I would like it to look just like a
text box, except that it would only allow you to enter certain values (key
values that come from another table).

Can anyone tell me if there is a way to do this?

Thanks,
Paul
--
Paul Kraemer