add a data to a column in a listbox

[anush]

hi
i need to copy from a textbox to a column of a selected item...i tried this code
Me.lstList.Column(1,1) = Me.txtQty.Valu

but the value always comes as null..

can somebody please help as to where i am going wrong..
or how to use AddItem to add to a specific column in a row.

thanks

 

[Douglas J. Steele]

Access only supports bound listboxes. You can't easily do what you're trying
to.

 

[Dave]

You could make a temp table that could act as the source of the list box
when you want to add items from your text box to the list box
you could add the data to the table abd then requery the list box.

 

[anush]

thank you so much..its a good solution , but i am suprised that Access doesnt support this....there is no way to assign contents of another control to a listbox column..


----- Dave wrote: ----

You could make a temp table that could act as the source of the list bo
when you want to add items from your text box to the list bo
you could add the data to the table abd then requery the list box