It sounds like a "null" value error, if you look at sql query then it will also not hold any values. If your form has another table field on it that does have a value the form will probably work OK even though the text box is blank. You can overcome this by making the default value for your table field either 0 for number values or " " for string values.