I just changed that column to allow it to be NULL and I am sure that that is it. But I have been trying to get the form to do other things and at the moment it isn’t working and won’t be until I fix that and so i can’t actually see just now if it is working or not. But I am sure that that was the problem and will post again as soon as i know.
Thanks for you help.
Shane