how to pull a record to a form and save it to another table

  • Thread starter Thread starter Lorraine
  • Start date Start date
L

Lorraine

hi,
I want to pull data from more then one field ( as it seems with a combo
box with multiple fields listed in a row ) and have it save these fields to a
diffrent table. What I'm trying to do is take a Whole record and save that
record to a new table.

Thanks
L
 
Why? It's seldom a good idea to store redundant copies of data.

You can use an INSERT INTO query:

Dim strSQL As String

strSQL = "INSERT INTO TheOtherTable(Field1, Field2, Field3) " & _
"VALUES(" & Me.txtNumericField & ", """ & _
Me.txtTextField & """, " & _
Format(Me.txtDateField, "#\yyyy\-mm\-dd hh\:nn\:ss\#") & ")"
CurrentDb.Execute strSQL, dbFailOnError
 
Back
Top