Where to start?
I am a VBA beginner so please play nice.
I have a form which displays all our products in a list. Click a product and this displays the Products Details page, pretty standard set-up. This pulls all the information from the products table.
However,
I would like a button and text box which allows me to enter a quantity then click 'Order'.
I would then like the product information (i.e. ProductID, Name, Description etc & the user inputted quantity etc) to be put into seperate table much like a shopping cart on a website.
I can then add a number of items to this table (cart)
I have seen many different ways of doing this but none seem to work or suit.
Please help!!!