Copy Record Help

[mattm31]

On a click of a button on a Access 2000 DB i need to copy the current record into an existing table and then pop a form showing that record,

Any ideas on doing this would be good.

Thanks

 

[mattm31]

Sorted it, Just didn't think about it.

 

[mattm31]

Well i thought i'd done it. I created an append query to
append the current record which work but now it doesn't and i have no idea why it has stopped working.

I just will not append any records.


Any ideas

 

[mattm31]

OK Got it working again, Created a macro to run
it with the openform action so the form opens as well
but i can't get it to goto the record.

Any suggestions ?

 

[PHV]

In 4 posts you've said absolutely nothing consistent for someone to help you !
Please, read carefully the 2nd FAQ in my signature below.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mattm31]

Sorry
What i'm looking for is a bit of code that when i have
Form1 open and click a button to open Form2 it will open on the same record (Which is the PK Field)

 

[PHV]

Have a look at the 4th argument of the DoCmd.OpenForm method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886