Private Sub client_id_AfterUpdate()
If Me.NewRecord Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
sSQL = "INSERT INTO invoice_sub_sub ( invoice_sub_id, product )" _
& " SELECT " & Me.id & " AS invoice_sub_id, title AS product FROM helper_goods"
CurrentDb.Execute sSQL, dbDenyWrite
Call Form_Current
End If
End Sub
|