I have a continuous form each line is a different product. I would like to
have it so that as the customer looks through the products they can enter the
qty they want to buy and it automatically adds it to their order.

I have the following forms.
customer
orders / subform order details
customer catalog ( continuous form)
Products

it would be like using a shopping cart on the wed.
is there an example on how to do this?
I am familiar with access but not the coding

One way is to have order form to enter CustomerID and button to make order.

That button runs an append query that append a record of each product
available to the Orders table with CustomerID and OrderDate default Now() and
displays in subform.

Customer scroll and enters quanity into the subform.

Then another button to complete order that deletes all records in Orders
table without a quanity and any other ordering actions such as printing
shipping report.

"Elbe" wrote:

> I have a continuous form each line is a different product. I would like to
> have it so that as the customer looks through the products they can enter the
> qty they want to buy and it automatically adds it to their order.
>
> I have the following forms.
> customer
> orders / subform order details
> customer catalog ( continuous form)
> Products
>
> it would be like using a shopping cart on the wed.
> is there an example on how to do this?
> I am familiar with access but not the coding
>