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!PurchaseForm.ItemName = me.ItemBox.Column(1)
but its not working