Check Box

[nancy]

I have a form where I have multiple names with check boxes next to the name.
I would like to have a contol button that will run a program that looks at
the selected names and then enter the information into a table.

I am not sure how to get started.

I type up this but I get a mismatched value with the first line.


If Check19 Is True Then

If DCount("WorkID", "Woklog", "volID=" & cboName & " And
WorkDate=Date()") = 0 Then

DoCmd.RunSQL "Insert Into WorkLog (volID, wlDate, SignIn,
AltName1) Values(" & cboName & ", Date(),Time(), Person1 Name);"

 

[Damon Heron]

Try this:

If Check19 Then

If DCount("WorkID", "Worklog", "volID=" & cboName & " And WorkDate=Date()")
= 0 Then
DoCmd.RunSQL "Insert Into WorkLog (volID, wlDate, SignIn, AltName1)
Values(" & cboName & ", Date(),Time(), Person1 Name);"
End If
End If

Damon