edit a list box

[Jollywg]

On a form how can i have a user change the value of list box. right now i have a two column listbox and i need them to change it without going and messing with the table? Any ideas?

Thanks
Matt

[missinglinq]

Sorry, Matt! If the listbox is based on a table, you'll have to "mess with the table" if you want to change it! A little more explanation might be in order.

Linq ;0)>

[NeoPa]

Matt, I'm afraid you'll have to be a bit clearer about what you want. There are so many possible interpretations of your question ("changing" a ListBox?).

PS. Snap :D

[Jollywg]

Matt, I'm afraid you'll have to be a bit clearer about what you want. There are so many possible interpretations of your question ("changing" a ListBox?).

PS. Snap :D

I think that what I'm asking for isn't possible, but what I'm trying to do is take a list box with two columns, and i want the user to be able to change the values of a column without going into the table ie:

List Box
______
A 1
B 2
C 4 <- the user needs to change the 4 to a 3

I hope this is a little clearer?

[NeoPa]

That's much clearer now, and you're absolutely correct in that a ListBox control is not able to update the data within it. It's essentially a Read Only control.

To manage the data a subform may be more appropriate for you.