>I am sure this is a simple question but I keep getting errors. I have 2 lines of code:
>
>

INSERT INTO tblmytable1
>SELECT * FROM tblmytable2

>
>I keep getting Compile Error Syntax Error. Any help would be appreciated.

I think you need to terminate the sentence with a semicolon (;).

INSERT INTO tblmytable1
SELECT * FROM tblmytable2;

HTH