>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