Limit To List Issue

[Lynn_AccessUser]

I have a combo box on a subform that I would like to limit the user to the list. However, when I set Limit To List = Yes . . . the user can not type in a value if they know it even if it is in the list.

The error message states:
The text you entered isn't an item in the list.

The text is in the list though. If I set Limit To List = No, the user can then type in the value.

I know I can set Limit To List = No and then write the code to handle if a user types in a value that is NOT in the list. But I don't understand why this isn't working to begin with.

Thanks!!

 

[dcx693]

Does it sound anything like this problem?: Combo boxes with non-numeric entries

 

[Lynn_AccessUser]

It doesn't sound like the same problem. All of the data is int.

Another problem I am having on one of the combo boxes is that it won't let me set Limit To List = No if I have the first column which is the bound column width = 0.

It keeps giving me an error:
MS Access can't set the LimitToList property to No right now.
The first visible column, which is determined by the ColumnWidths property, isn't equal to the bound column. Adjust the ColumnWidiths property first, and then set the LimitToList property.

Problem is I don't want to show the bound column because it then shows that column value on the form and I want the 2nd column to show on the form but the value in the 1st column will get saved to the table.