Creating a Shopping cart type of form

[hansnyc]

Hello,

I have a basic Customer/inventory form with basic data on the customer

then a subform with the items in storage for that customer, his/her inventory

with itemID CustomerID(refcustomer) Itemname and ItemDescription

My issue is Customer might check out an item and sometimes restore it a few months later.

I'd like to create a "cart" where I have a cmdbutton next to the items listed on the subforms, when I click on it it sends that item to a "checkout form" or "release form"
The ideal would be to select or be able to send multiple items to this "realease form" then once the release form is confirmed (saved) the items would be deleted from the tblinventory. And into this release tbl. I could then have a record of the items being check out and also print out a report of that release form for records.

Now when the customer brings these items back to his storage I could use a "check in form" and restore them in his inventory.

Now how the [censored] can I do that?

Anyone could point me into the right direction?

Thanks

 

[Guus2005]

your release form should have a listbox, a subreport or be a continuous form.

 

[hansnyc]

your release form should have a listbox, a subreport or be a continuous form.

Can you point me out on how to do this please?

Thanks for your time

 

[Guus2005]

when you use a listbox you can store the items in the listbox and later save the the items on the listbox to your table or you can store the items directly in your table and bound your listbox to the table. in the first option you can easily cancel the shopping cart with the statement me.listbox.clear. in the second option you must delete the items from your table.

lets say that you choose option 1.
program your button click event:

private sub button_Click()
    me.listbox.additem me.txtbox
end sub

This was my pointer in a direction.
You must program the save button where you must loop thru all the items in the listbox and save them in your table.

HTH