Where Condition with multiple value

[VSolano]

I will gladly apricate any help from this forum regarding this code.
I am passing various value from one from to another. The first part of the SQL works fine by when I adding another value it does not work. I tried the value with a variable and still I get the mismatch.

Private Sub Form_Open(Cancel As Integer)
Call taskschedule
Me.AllowEdits = False
Dim SQLDataSource As String
Dim STWhere As String
Dim Benf As Integer
 
Benf = Forms!frbillingtest!benefitsid
 
    SQLDataSource = " SELECT * FROM tbtaskschedule WHERE TaskAssignedTo = " & TempVars![SYSID] And TaskBenefitID = "  & forms!frbillingtest!benefitsid  "
    
    
    
    Me.RecordSource = SQLDataSource
    Me.Requery
End Sub

 

[pbaldy]

This may help:

http://www.baldyweb.com/ImmediateWindow.htm

A type mismatch is usually because the field's data type doesn't match how you've handled it. Generally speaking, text data types need apostrophe delimiters. This may help with that:

http://www.baldyweb.com/BuildSQL.htm

 

[arnelgp]

SQLDataSource = " SELECT * FROM tbtaskschedule WHERE TaskAssignedTo = " & TempVars![SYSID] & " And TaskBenefitID = " & forms!frbillingtest!benefitsid

 

[VSolano]

This is great information but I could not figure out the problem with my SQL