how can i edit values in a list box

[faz848]

On my main form i have a list box which has details of actors and their roles.The rowsource type is a table/query and it works fine.

But i would like to add and edit the values of the list box but it doesnt allow me to do this as the rowsource type isnt a value list

How do i get the data that is currently in the list box if i change the rowsource type to a value list so i can add and edit the data?

 

[Remou]

The best bet would be to create a form based on the table that appears in the list box. This is far easier than manipulating a value list. You can use a button to pop-up the form or take advantage of a combo with a NotInList event. Do not forget to requery the listbox after you have added and / or edited records.