adding sql to forms

[shanewa]

I was given this sql code to add to a form so that the text and combo boxes would be inserted into the tables. but I do not even no where to begin or if the code is any good.

Dim strNewRecord As String
Dim strSQL As String
Dim rst As Recordset
Dim dbs As Database
Set dbs = CurrentDb

DoCmd.RunSQL "insert into Fork values(Me![gserial],me![cmbtype])"
'Set rst = dbs.OpenRecordset(strNewRecord)


DoCmd.RunSQL "insert into fork_2 values(Me![ssn],me![tageqid],me![issuedate],me![updated])"
DoCmd.SetWarnings False
DoCmd.SetWarnings True


DoCmd.GoToRecord , , acPrevious
Me.Refresh

 

[ToeShot]

what is it you are trying to do? Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[shanewa]

I have a form whose source is a table. I also have several more text boxes on the form whose source is another table. I would like to add information from this form as a new record to these two forms.