Create a command button that create a particular table

[Lreader]

I have a form to compile course evaluation. This form is base on a table called "activity"and on a subform called "questions".
I need a button command in this form which create a table with the actual record parameter.Ex: I just finished to fill the form and I want a button command to create a table with the record I filled.

This table is useful because I build a report based on this table. Actually, I used parameters in a query which create this table but I would be more fine to do this in one step when I am working in the form.

 

[gcole]

'create code behind your button like this:
'this creates a table called acctsbak from the accts table
'make sure you include:
Private sql_def as String

Private Sub cmd_mail_Click()

'backup accounts information
sql_def = "SELECT DISTINCTROW accts.* INTO acctsbak FROM accts"
DoCmd.SetWarnings (False) 'turn overwrite warnings off
DoCmd.RunSQL (sql_def)
DoCmd.SetWarnings (True)

End Sub