I have a problem with default values in my SQL Server tables.

I have a table with default values set to some fields, but I find that when I bind my controls to those fields, they do not get the default value when I insert a new row, nor does the table save the default value when I insert a new records without specifying a value for it.

I still get the Null not allowed error on end edit.

When I open the SQL table and try insert, it works just fine.

Any ideas what's going on?

I think that, because the controls are bound, they get a value from what they aer bound to, so that the control’s default is never invoked; a sheer guess . . .