>>Then we get the following error
>>
>>Microsoft VBScript compilation error '800a03ea'
>>
>>Syntax error
>>
>>/snworld/newsite/Global/DetailPublicVerify.asp, line 25
>>
>>Recordset1.Source = "SELECT * FROM datahistory where Docket_No = '" + & HAWB + "'"
>>
>>
>In VB single quote starts the comment, although I think it should be ignored when it's a part of the string variable. Also, why do you have & and plus?
>
>You need to have either + or & but not both of them.
Sent your reply to my programmer - thanks for your help so far
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing