Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "