How do I append records from temp table to main table using VBA?

[qu1ncy]

Hi,

I'm working with Access 2000. My users build claims and add them to a list box on a form which is based on a temp table. Once they've verified the list of claims they add these (one or many) claims to a permanent table waiting to be paid out. I'm currently using an Append Query which gets run on the click of a button. This query moves any claims in this temp table to the permanent table.

I would like to know how to do this using code instead of the OpenQuery method.

Thanks in advance.

Q

 

[BrainB]

Here is a snippet of code which I hope you can convert :-

'- Appends all Adjustments Table records to YP17 Table
CurrentDb.Execute _
("INSERT INTO [YP17] SELECT * from [Adjustments];&quot


Regards
BrianB
** Let us know if you get something that works !
================================