Hello All,
I am in need of urgent solution to this protracted issue I am having with Search Form using Combo box. The error code 3464 - Data type mismatch in criteria expression. The code is pasted below: the issue is with shaded 4 (line 4)
Private Sub cboYear_AfterUpdate()
Dim myGermplasm As String
myGermplasm = " Select * from tblGermplasm where Year = '" & Me.cboYear & "'"
Me.tblGermplasm_subform.Form.RecordSource = myGermplasm
Me.tblGermplasm_subform.Form.Requery
End Sub
Your prompt support is highly appreciated. Thank you
I am in need of urgent solution to this protracted issue I am having with Search Form using Combo box. The error code 3464 - Data type mismatch in criteria expression. The code is pasted below: the issue is with shaded 4 (line 4)
Private Sub cboYear_AfterUpdate()
Dim myGermplasm As String
myGermplasm = " Select * from tblGermplasm where Year = '" & Me.cboYear & "'"
Me.tblGermplasm_subform.Form.RecordSource = myGermplasm
Me.tblGermplasm_subform.Form.Requery
End Sub
Your prompt support is highly appreciated. Thank you