Solved VBA To Filter A Sub Form (1 Viewer)

[jo15765]

I am attempting to use this to filter a sub-form

frmSaleItems.Form.Filter = "[ItemId] = '" & Me.Combo7 & "'"

but i keep getting this error

Datatype mismatch in criteria expression

What should I change in that vba line to remedy this issue?

 

[June7]

If ItemID is number type, remove apostrophe delimiters. They are used with text type field. Use # for date/time type.

 

[jo15765]

If ItemID is number type, remove apostrophe delimiters. They are used with text type field. Use # for date/time type.

I've LITERALLY been sitting here for 30 minutes on that error....geez i've been out of access vba for to long