Value for Checkbox

[kathyc20]

I have a table with a checkbox in it (Yes/No) and I'm using a query to add the current record in the form to another table. sTemp(1) and (2) and strings and (3) is the value of the checkbox on the form. I display the value of sTemp(3) and got -1 (my checkbox on form was enabled). Tried to run
query and got error type conversion? How do I add this?


sSQL = ""
sSQL = sSQL & "INSERT INTO [Security Info History] "
sSQL = sSQL & "("
sSQL = sSQL & "[Employee Number], [Alarm Security Code], [Security Code Activated] "
sSQL = sSQL & ") "

sSQL = sSQL & "VALUES "
sSQL = sSQL & "("
sSQL = sSQL & "'" & sTemp(1) & "', "
sSQL = sSQL & "'" & sTemp(2) & "', "
sSQL = sSQL & sTemp(3) & " "
sSQL = sSQL & "); "

 

[dhookom]

You need to learn to debug your code. Place this line after your final sSQL= line.

  Debug.Print

Then set a break point so that you can capture the sSQL value and paste it into a query and view the results. Viewing the sSQL might reveal an embedded quote or something.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]