can anyone see what is wrong with this line as I can't get
it to work !

sql = "SELECT * FROM FQPack WHERE PalletNo = ' " & trim(txtdeletepallet) & " ' "

when I do this it works fine
sql = "SELECT * FROM FQPack WHERE PalletNo = '559294017' "

I have set up a text box (txtdeletepallet) to allow only
numeric entry and I want this to be my search criteria
against the palletno in FQPack rs.

> thanks for looking