>Thanks Craig... I'll give that a try.. I think I am going to move it to the SAVE button on the ADD/EDIT toolbar. Then just RETURN it back with a SETFOCUS to a field to correct. But this brings up another interesting point... when is a field NULL vs BLANK (or 0)?
>
>
Do you remember discussing the "Empty Set" in high school math classes? It meant that no value was contained there. That's a NULL. NULL is not 0. It is not blank. It means "I don't know what the value is".
A field is NULL when the user doesn't enter a value AND you allow NULLs in the field. Most fields allow a value. You have to explicitly allow nulls.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer