copying data between dif. tables

[nicktheblue]

Hello all,

can anyone give me a simple answer to this (Access 2000) question...

I have a form called "PurchaseQuotes" with a subform "PurchaseQuotesDetails" with a number of fields including things like 'supplier', 'item number', 'price', 'quantity' etc. - I'm sure you know the script. I am trying to make a command button on the form which will copy all the field data into a new record in another form called (you guessed it) "PurchaseOrders" with a subform "PurchaseOrderDetails" with matching fields.

Now, I am thinking -

on_Click()

DoCmd.OpenForm PurchaseOrders , acNormal
DoCmd.~~~~~~~acNewRec (should all be on one line?)

----then I'm totally lost till something like----

me!OrderID = PurchaseOrders!OrderID
me!OrderDate = PurchaseOrders!OrderDate
etc.

question - am I barking up the right tree?
If so, do I need to - erm - mention the subforms in the command lines somewhere or does access just **understand** what I'm getting at (unlikely!!!!!!)
If not, what is the right tree?

as you can probably see, I'm well out of my depth here!

any help will be much appreciated!

Nick