Simple SQL Question

[paul]

Hi
I nee dto insert data int a table.I think this code will do what I want.
strSQL = "INSERT INTO Cross (Oem,Cross#,Description) SELECT Form!Form2.Text1, Form!Form2.Text2,Form!Form2.Text3"
How do I execute this command and is there any good examples availible?
Also I ame using MS Access 2000 and to get it to work I have to convert the database to an older version . What can I do to use the latest version?
Thanks for any help.

[titanium]

try this code:

"INSERT INTO Cross (Oem,Cross#,Description) VALUES (Form!Form2.Text1, Form!Form2.Text2,Form!Form2.Text3)"

for ASsess2000, you have to use JET.4.0 instead of JET3.51 for the .provider.