Transferring the contents of a table

[MattBeas]

Hi!
I Need some help!!

I have 2 tables. a ProductsTbl and a TempTbl

On entry into a form I need to copy the contents of the ProductsTbl to the TempTbl.

Does any know how to copy the contents of one table to another. The tables have exactly the same structure.

Any solutions would be greatly appreciated!
Thanks!

 

[UncleJack]

Use a simple append query. You can do it in SQL:

DoCmd RunSQL "INSERT INTO TempTbl SELECT ProductTbl.* FROM ProductTbl;"

or you can use the query designer to create an append query and then call it from code:

DoCmd.OpenQuery "CopyToTemp"

Placing the above code in the On Open event of your form should do it.

Uncle Jack

 

[MattBeas]

Thanks Uncle Jack, I'll give that a shot!