Hi!
I am having an issue with using two different criteria to filter a form and am asking for some assistance!
The Part Type Def data type is short text and that part of the code works fine.
When I added in the Workorder_ID, which is a numeric data type, I am getting a mismatch error.
Any thoughts on what I'm missing? I've searched and searched and can not find a solution that works. Any help is greatly appreciated! Thank you!
Private Sub PART_TYPE_DEF_DblClick(Cancel As Integer)
Me.Filter = "PART_TYPE_DEF Like '*" & Me.PART_TYPE_DEF & "*'" And WorkOrder_ID = "& Me.WorkOrder_ID"
Me.FilterOn = True
End Sub