Hello Everyone, I'm new to Access and new to VBA so please bear with me. I'm learning as I go essentially, which means watching a ton of YouTube videos, googling, and searching wonderful forums such as this. I'm trying to create a simple Search Form using a combo box. I followed the guides.....checked and double checked the little VBA work I did, and I of course receive an error without understanding why it's giving me an error or how to fix it. It's giving me a Run-time error '3464': Data type mismatch in criteria expression.
Private Sub cboSupName_AfterUpdate()
Dim mysup As String
mysup = "Select * from tbl1EmployeesInfo where ([SupervisorName_ID] = " & Me.cboSupName & ")"
Me.tbl1EmployeesInfo_subform.Form.RecordSource = mysup
Me.tbl1EmployeesInfo_subform.Form.Requery
End Sub
Any assistance would be greatly appreciated Thank you
Private Sub cboSupName_AfterUpdate()
Dim mysup As String
mysup = "Select * from tbl1EmployeesInfo where ([SupervisorName_ID] = " & Me.cboSupName & ")"
Me.tbl1EmployeesInfo_subform.Form.RecordSource = mysup
Me.tbl1EmployeesInfo_subform.Form.Requery
End Sub
Any assistance would be greatly appreciated Thank you