I have a form.. with a combo box with names from my query.
I have a checkmark box from my table..
I want to be able for the user to select name with combo list.. hit a button and that check mark box will become check in that table.
ok now what I've done..
set the default check mark box to true..
and the code behind the button:
Private Sub bSave_Click()
Dim f1 As String
Dim f2 As Boolean
Dim strSQL As String
f1 = EmpName.Text
f2 = IIf(DelEmp = True, True, False)
strSQL = "UPDATE Table1 SET Table1.DelEmp = " & f2 & " WHERE Table1.Name = " & f1 & ""
now the error i get when i run the code:
Run-Time error 3075
Syntax error (comma) in query expression 'Table1.Name = Name in Table'.