Apologies... I dont seem to be able to paste a screen shot in..

Here are the results for the watches...

sht.Cells(lngRow, 13).Value value = "200 type = variant/string
QuerySearch.SearchAmount.Value Value = False type = variant Boolean
QuerySearch.SearchAmount.Value = sht.Cells(lngRow, 13).Value value = "PAYMENT AMOUNT" type = Variant/string

Context is same for them all QuerySearch.Search_Click

Thanks, Aaron

[IMG]Desktop\screen.bmp[/IMG]