I am trying to insert a SampleID(autonumber), ArticleNo(number), and SamplePoint(Text) into a table set up for the results. I need the Sample ID, ArticleNo and SamplePoint to tie the results table to the Samples Taken Table. I have searched the internet and tried several different samples that have not worked. Below is the latest approach I am trying. I am kinda new and am desparate for help.
Private Sub DateLogged_Click()
Dim SampleID As Integer
Dim ArticleNo As Interger
Dim SamplePoint As TextBox
dbs.Execute "INSERT INTO FGResultsTable(SampleID, ArtID, SPID)" & _
"SELECT (SampleID, ArticleNo, SamplePoint)" & _
"FROM FGSamplesTaken;"
dbs.Close
End Sub