save to multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

how can i use the click event of a command button to save info. from a field
on a form to another table besides the record source table? I guess it should
be simple, but i can't figure it out.


Thanks in Advance
Ernie
 
Hi Douglas

Thanks for the speedy response. But how do i execute an insert into (or
update) query after i click the save button?

Ernie
 
Private Sub MyButton_Click()

Dim strSQL As String

strSQL = "INSERT INTO [SomeOtherTable] (Field1, Field2) " & _
"VALUES(" & Me.Text1 & ", '" & Me.Text2 & "')"
CurrentDb.Execute strSQL, dbFailOnError

End Sub
 
Back
Top