Copying record to another table

[roccogrand]

I need to copy the record on a form to another table. I have tried various
versions of this statement both with and without brackets and parentheses
around the field names:

DoCmd.RunSQL ("INSERT INTO tblMembers (First , Last) SELECT Me.First ,
Me.Last")

The field names in both tables are the same. Access knows the correct
values on the form because Debug.Print shows the values. The statement above
is a valid parameter query but I want the values on the form to be copied
into the destination table "tblMembers".

What am I doing wrong?

In Access 2007.

Thanks.

LDN

 

[PJFry]

Try this:

DoCmd.RunSQL ("INSERT INTO tblMembers (First, Last) VALUES ('" & Me.First &
"','" & Me.Last & "')")

PJ

 

[roccogrand]

Thank you.

I must have wasted two hours last night trying to figure it out.

LDN