Execute Insert Statement When Checkbox Is Ticked?

[dapoole]

Hi there,



I'm trying to get an Insert statement to execute whenever the user ticks the tickbox however my code is failing to find the output table 'Manager':

Private Sub Check34_AfterUpdate()
 Dim db As DAO.Database
   Dim qdf As DAO.QueryDef
   Dim varItem As Variant
   Dim strCriteria As String
   Dim strSql As String
   Set db = CurrentDb()
    
If (Me!Check34) = -1 Then


DoCmd.RunSQL "INSERT INTO Manager (manID) " _
 & "VALUES(" _
 & "'" & Me!empID & "') "
   
  End If
  
End Sub

Please can you advise?

TIA

[lfpm062010]

Change it to make it easier to read. I put an space between "VALUE" and "(". Anyway, try the code below to see if you still getting errors. Post exact error message if you can.

One more thing, does the table "Manager" exist with column "manID"?

Private Sub Check34_AfterUpdate()
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSql As String

Set db = CurrentDb()
If Check34 = -1 Then
strSql = "INSERT INTO Manager (manID) "
strSql = strSql & "VALUES ("
strSql = strSql & "'" & empID & "')"
DoCmd.RunSQL strSql
End If
End Sub

[dapoole]

Thanks but it still fails after tidying up the code. Exact error message is "Run-time error '3192': Could not find output table 'Manager'."

The manager table is a linked table and does exist with a unique key manID which links to Employee empID.

[lfpm062010]

I have tested the code and it works.

Is the linked table "Manager" in SQL SERVER, or another Access database, or Excel, ......?

Can you also verify what column "manID" data type (is it TEXT, NUMBER, .....)?

[dapoole]

It's SQL Server:

CREATE TABLE test.dbo.Manager(
manID INT,
manForename VARCHAR(50),
manSurname VARCHAR(50))

I can connect to the table and view it's contents so the tables exists. The problem must be in the VB code somewhere?

[lfpm062010]

Ok, do you have table "Manager" listed? or is it "dbo_Manager" or something?

[dapoole]

That's it thanks. I had the insert statement written as INSERT INTO Manager when it should read dbo_Manager. Many thanks.