Thank you Ajax. You have made my day and I am happy.
So you want the update to cancel if at least one of the txt boxes is blank or if all of them are blank?
Nick
Yes i want to cancel if at least one of the boxes is blank is blank.
More to the point, I would like to specify that only one of[txtTargetIncrease], [txtMthForecast], [Text549] can be filled at a time. If one is filled then the other two must be blank. but [txtCurrentRisk] can be filled at the same time as any one of the first three, or on its own. But I do not have a clue how to write that, so thats why I went with the simple option. it does not satisfy my database criteria but I don't know how to get around it.......unless someone is willing to help me.....wink wink.
Nadine.