adding new record with MS data form wizard? If you are dealing with a SQL database use INSER

I have some problems with the data from wizard item

the wizard asks for dataset, connection, tables, & in lst view, since i want the add, delete updata all buttons, i select the non grid view [individual records that is]

Now i have been succesfull in updating any record MashaAllah, haven't tried the delete for some reasons, but the code seems to be understandable

but i can't figure out how to add new recordds?

when i press the add button, it either says column "columnName" can't be NULL or simply UPDATES the existing selected record
]

I want to add new record, am i suppose to add some code for this? whats the shortest possible way?

[697 byte] By [maqk] at [2008-2-25]