hpublishb LIKE '" & TextBox2.Text & "%' and hcustname like '" & TextBox4.Text "%'
--->
hpublishb LIKE '%" & TextBox2.Text & "%' and hcustname like '%" & TextBox4.Text "%'
--->
hpublishb LIKE '%" & TextBox2.Text & "%' and hcustname like '%" & TextBox4.Text "%'
isnull(hpublishb,'') LIKE '" & TextBox2.Text & "%' and isnull(hcustname,'') like '" & TextBox4.Text "%'