If I understand you correctly, you tried to retrieve some data into a recordset and you want to know if you got anything back. <BR><BR>If you didn't the recordset's ".EOF" property will be true. (In other words you tried to retrieve something, got nothing, and were left with the End Of File marker so .EOF was true.<BR><BR>Now if you want to test the value of a particular field, then after I test .EOF I generally use a semi-bulletproof "threesome" of "IF NOT IsEmpty(<field>) AND NOT IsNull(<FIELD>) AND LEN(<field>) > 0 THEN". It might be a whole lot of overkill but it hasn't failed yet.<BR><BR>Hope that helps.<BR>
cheers, thats helped! it was a particular record item (eg: 9th record in recordset, value of Name field). Don't know whether thats clear or not?!?! Simply a check to see if a value is empty, then to change it to the value of another variable.