It looks like you probably used the variable surname as part of a SQL statement. With SQL, the value has to be quoted by ' such as: select * from myTable where name = 'John Smith' If the name value itself contains a ', the SQL statement is invalid: select * from myTable where name = 'John's Smith' What you need to do is replace ' with two consecutive ', like the following: select * from myTable where name = 'John''s Smith' CStr(Replace(Trim(surname), "'", "''")) Good luck.

As Steve pointed out, you're trying to access a record's data but you've either gone past the end of the records, or none were returned. If you use Do While Not Recordset.EOF then you can loop through and anything done inside the loop will be on valid records (providing you use Recordset.MoveNext inside the loop). Alternatively, use If Not Recordset.EOF if you're only expecting to have a single record returned. -- Paul "If you can keep your head when all around you have lost theirs, then you probably haven't understood the seriousness of the situation." - David Brent, from "The Office" MS Messenger: paul@oobaloo.co.uk Sonork: 100.22446

:-D Many Thanks Bravo Two Zero A pen is mighter then a sword.

BravoTwoZero wrote: and calling a function onchange="popVal()" in txt1. function popVal(){ window.document.form1.txt2.value = window.document.form1.txt1.value } This won't work as you have noted when you are setting the values programmtically. No "event" has taken place for that function to be called. I would assume that you are either loading the pop up calendar either with the onLoad event or by clicking a button. I would suggest that you add an additional function call to check the value of txt1 after the function has returned, then populate txt2. Hope this helps. Nick Parker May your glass be ever full. May the roof over your head be always strong. And may you be in heaven half an hour before the devil knows you’re dead. - Irish Blessing