>I did, I just forgot to put it in my message. Part of my problem was that I didn't put DoCmd.RunSQL but it still doesn't work. Here is my actual code:
>
>

DoCmd.RunSQL ("INSERT INTO temp_mold")
>Select * From Product;

>
>I am just having a hard time figuring out where to put the "" and ()

You are trying to take the result of the SELECT statement and send it into temp_mold?

If so, then the statement should be all within the "" as in:

"INSERT INTO temp_mold Select * From Product;"

HTH