Hi,
Further to my post earlier today, that I now can't see ......I have found out the answer as to why it wasn't working.

When the If statement was evaluationg the 3rd column of the combo box it was checking for the value No but it should have been checking for the value "No"..................................I had left out the " " around the value


Regards
John