Hi folks,

I am having a problem inserting a record into my sql2000 database. Following is the error message I receive.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'myGoals', table 'PAB.dbo.tbMembers'; column does not allow nulls. INSERT fails.

Here is the scenario,

I am using the insert record behavior to insert 10 form fields into a sql2000 database table which contains 20 fields. My members will complete the remaining 10 fields on another page including the field "myGoals" which caused the error after this first form is passed and the record is inserted.

Why do I receive this error? is it not possible to insert a record that fills a portion of a table with the MM insert record behavior. If not how do I get around this?. I have searched the board for a answer or tutorial but have come up empty.

If anyone could help by guiding me to a tutorial or a solution it would be much appreciated.

Thanks in advance,

Robert

Dear Robert,
Change 'myGoals' properties to allow NULLs.

Regards,
Brent

Or alternatively don't insert the record till the user has filled in the second 10 fields

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome