TRANSFER DATA FROM ONE TABLE TO ANOTHER USING A FORM

[billquga]

I have a form set up to enter data. As I enter data, certain fields update into a "total" field. Is it possible to have that data transfered from this table to another table using a button witin the form, or either a code within the fields? Any help would be appreciated.

 

[SyedAqif]

Yes it can

Use Select Into Statemetn as:

The following example selects all records in the Employees table and copies them into a new table named Employees Backup:

DoCmd.RnSql ("SELECT * INTO [Employees Backup] FROM Employees;&quot

The next example creates a new table called Sales Representatives that contains only employee records that have the title Sales Representative:

DoCmd.RunSql ("SELECT Employees.FirstName, LastName INTO [Sales Representatives]
FROM Employees
WHERE Title = 'Sales Representative';&quot

I copied the text from Access Help....U can furher search into for SELECT INTO clause. You can run one of the above code behind any button. I hope u've got the idea required

Cheers!
Aqif