can someone point me it the right direction need help Please!!!!!!

E

Elbe

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top