order form?

[louis-m]

Hi, i'm struggling with an order form. i'm trying to create a switchboard where the person clicks on a button "create order" which then opens up a new form, allows them so insert multiple orders onto the form and then at the bottom of the form "commit order" and then all the selections go into an orders table.
any help or pointers would be great.
thank you,
louis

 

[ezfriend]

May not be the best suggestion, but it's a suggestion.

Create a field in your tblOrder. Let's say [TempOrder (True/False)]

Let you user create as many orders as they want, but when user click on Commit Order, just turn that field to FALSE. If Cancel (or form closed), just clear everything from the table with TempOrder = TRUE.

This work if only one person is using the database.