Never mind guys, figured it out, after 6 hours I figured it out 15 minutes after asking for help hahaha
If anyone is interested
Dim entry As String = "'%" & txtbxMANU.Text & "%'"Newreport("SELECT * FROM [Instruments table] WHERE [Manufactuer] LIKE " & entry)