Put data into subform with click on List Box items

[ZKAHADI]

hi buddies.

i am working on MS Access Purchase system . i made a form with a subform name PurchaseForm contain ID, ItemName, ItemQuantity, ItemPrice, TotalPrice and i made and Item Listbox name ItemBox contain items names.
i want to click the item name in listbox and it fill into subform itemName. as i click the item fill in box and another row made.

how i can do this.

i tried like this on click even on ItemBox like
forms!PurchaseF orm.ItemName = me.ItemBox.Colu mn(1)

but its not working

[isladogs]

Assuming you really do want the second column data from the list box, then possibly this

Me.PurchaseForm.Form.ItemName = Me.ItemBox.Column(1)

You may find this link useful Reference Controls on subforms

[NeoPa]

I would add that it may be very helpful for you to see Forms and Reports as being like windows - I mean the ones with glass you can see through.

None of the lovely scenery outside of your house is contained in the window itself. It merely allows us to see it nicely.

The same is true of Forms and Reports. Certainly, there are trimmings you can add to the window which you'll see every time you look at it but it doesn't store the outside. If you want data to be stored then you have to save it in a table somewhere. When the data's safely in the table it's then visible via your Form or Report.

[ZKAHADI]

this formula worked but i cant add new item to next row.
i tried like

Me.PurchaseForm .Form.ItemName = Me.ItemBox.Colu mn(1)
docmd.gotorecor d , , acNewRecord

but unfortunately this not work too

[NeoPa]

I'm sorry. With so little information in your response I have no idea what you're trying to say.

[ZKAHADI]

when i click the item listbox to put data into subform it updated but if i again click then new row is not create
the same row data is changing.

[NeoPa]

I'm still very unclear but perhaps if you tried putting the first line after the second it might work. Again, I have far too little understanding of what you're talking about to be sure, but it might be worth a try.

[ZKAHADI]

let me explain....

when i click on listbox the item name and price added in subform first row.
if i click again on itembox the item not going add in new row.
it update in old row again.

i want if i click the item name the item add in first row on again click item added in new row same one by one new row made.

[isladogs]

If I understand you correctly, the first record in the subform will be overwritten because you haven't moved off that before selecting another item from your listbox.