Updating Tables macro

[dgbrock]

Hello I use a database to track orders for a delivery business. The heart of the database is entering of orders in which 2 tables are used. An "orders" table which contains the customers name, the ship date and the order# (auto-number) and the "ordersdetail" table that contains the product and and quantity. The tables are bound by the order#.

I have customers with standing orders that are the same everyday. I would like to create a macro to automatically enter these and just don't know where to begin.

Any help will be greatly appreciated.

Thank you.

BTW I am using Access2000

[HiTechCoach]

One possible solution that I like to use would be to add a command button to the form for "Duplicate Order".

See:
Duplicate the record in form and subform


Hope this helps ...