Easy Question but I'm stuck

[frank]

Hello All,
I want to do something very simple and I am having a problem.
I am making a data entry form and I want to use a Combo box that
allows the user to select from existing values or enter a new value
before clicking the save button to insert the new record.

Every time I set the LimitToList property to false I receive the error
message:

"Microsoft 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 column widths
property first, and then set the Limit to List property."

How can I allow the User to enter a new value in the combo box or
select from the existing ones?
Thank You.

 

[Ken Snell]

That error message means that the Bound Column property is set to a value
that is not the column number of the first field with a non-zero value in
the Column Widths property. For example, if the Column Widths property were
this:

1";2"

then the Bound Column value needs to be 1 in order to set Limit To List
property to False.

If the Column Widths property were this:

0";1"

then the Bound Column value needs to be 2 in order to set Limit to List
property to False.

If the Column Widths property is

1";2"

and the Bound Column is set to 2, you'll get the noted error message when
you try to set Limit To List to False.