Question by  kimmiepooh35 (35)

What do I do if my Microsoft Access Combo Box won't let me change the values in it?


Answer by  PhoPho (153)

It all depends if your combo box is set to Autonumber. If this is the case, your values cannot be changed, unfortunately.


Answer by  emer30 (27)

go into the Combo Box 2 row, add the table's FKField; and in the criteria row under the FKField, Then, in Combo Box 1's AfterUpdate event, add the following lines of code: boBox2 = Requery boBox2 = Null.A combo box is a drop down list that gives you a list of things you can pick something from.


Answer by  kd97 (733)

There are many possibilities, but one of them would be to check and see if your form is updatable. If you can, change the values of the other bound controls on the form.


Answer by  alsoftware (117)

the dataset has not yet entered the "request live" state that is you can only view data and cannot modify it. If this is true not only you cannot change combobox values but you won't be able to change any data, that is editboxes, checkboxes and so on. Enable the request live mode.


Answer by  nimrod (321)

you first need to check the field assigned to that combo box to enable changing the values and also change the property "LimitToList" to FALSE


Answer by  BeefStrule (690)

That means you don't have the updated version. Go to Microsoft's website and download the newest version and you shouldn't have any more troubles.


Answer by  pratap63 (9)

The data source property might be auto number, in which case, it won't be possible to change the value in the combo box.


Answer by  japratt (1687)

If the combo box is not letting you change the values in it then you will just have to enlarge the box.

You have 50 words left!