Edit entries(List) of Combo Box

[racdata]

When I tried to edit or add an entry of the combo box, Access stop and reload the database. Access don't display any error message.
I re-install Office but it stays the same. Did anybody experience such a problem and what is the solution.

 

[CarlettoFed]

To give you an answer it would be necessary to have the file available to check if the error occurs.

 

[gemma-the-husky]

try a comma as the separator rather than the semi colon.
I take it you are in design mode with no code running in the background?

 

[Pat Hartman]

Use a table rather than a list if you have a list that can change. I've attached a mini-app that I use in all my applications to manage simple tables.

 

[gemma-the-husky]

With a value list, you can change the list in code.

MyComboBox.rowsource = "a new list"

maybe you then need either
MyComboBox.requery OR
DoEvents OR even
nothing at all

But you wouldn't stop the app, and redesign the combo box to change the rowsource. You could, but that is re-designing the database.

 

[Pat Hartman]

gemma, does that work with an .accde?

 

[gemma-the-husky]

gemma, does that work with an .accde?

I thought I had better check, although I was sure it does, and it did.
You can't save the value list as a design change, but you can change the value list at run-time.
Try this simple demo. This is an mdb, but make it a mde.

 

[Pat Hartman]

Thanks I was pretty sure you couldn't save the value list at run time in an .accde or when running under the Runtime engine which is why I would not recommend that method.

 

[gemma-the-husky]

Thanks I was pretty sure you couldn't save the value list at run time in an .accde or when running under the Runtime engine which is why I would not recommend that method.

As the OP was editing the row source directly, I assumed he just wanted to be able to change the list without going into design mode.

 

[Pat Hartman]

@racdata, If you are trying to edit the rowsource of the combo and save it while the form is open, keep in mind that you can't do this if your users are running an .accde or using the Access Runtime. Look at the sample I posted of how to manage simple lookup tables.