Event procedure (Insert into Syntax)

[hart270]

What is the Syntax for a insert into on click?

 

[Dugantrain]

I'm not exactly sure what you're asking. Can you be a bit more specific?

 

[hart270]

I need to create an event procedure on a form. So that when the field is clicked on it will insert the data in table / form into another table. I am having trouble with the syntax of the insert into statement.

 

[Dugantrain]

Well, you'd need ADO or DAO to hard-code this, but the cheap, easy, and maybe best (for Access, anyway) way to do this would be to use an Append Query and then call that query in the On_Click event of your command button.
So, first, the query:
Make a new query and under "Queries" select "Append Query". For each field, you can either explicitly write:

Forms!Your_Form.Form!Your_Field

as the name of each field that you want appended and then select which field it should be appended to in the "Append To" field. Or, if you have a Unique Identifier in each record in your original table (note: I use Autonums in every table as a Unique ID; they're very cheap and very reliable), you can simply add your original table that the data will come from to the query, select every field from your original table that you'd like Appended, and then select your unique ID field and in the Where field, write:

Forms!Your_Form.Form!Your_Unique_ID_Field
[code]
Note:  If this is an Autonum field, you'd want to leave "Append To" blank, as you don't actually want this number to go into your destination table.
Alright, so that takes care of the query.  Now, to call this query from code, you would write the following behind the form:
[code]
Your_Command_Button_OnClick()
DoCmd.OpenQuery "The_Name_Of_Your_Append_Query", acViewNormal, acEdit
End Sub
And it should work!