Hi there,
This is my first post; I hope someone could help me.
I am new on the VBA arena and have some difficulties in trying the following thing. I am currently using Access 2003.

I found clients tend to order the same thing from time to time. Taking the Northwind database as sample I need to add a bottom to "Orders form" to say "Duplicate Invoice" beside "Print Invoice". Basically, I would like to add a new invoice that copies the current Order record (apart from OrderID) and ALL the "Order details". I manage to copy the main order record however I do not know how to copy the records from "Order details" at the same time.

Any suggestions about the code I should use?

Thanks in advance.