Data-linked textboxes causing problems

[P.S.W.]

I have a form with several textboxes tied to an ADO Data Control and .mdb recordset.

If I type in a txtbox, then delete what I just typed in, so as to leave the txtbox empty, then try to to delete the current record, I get the following error:

"Multiple step operation generated errors. Check each status value".

I'm not sure what this means. I designed a work-around this problem by checking each txtbox, and if it is empty, adding thru code the number "0" into it, and then doing the .delete. When I do it this way, no error occurs. Surely there must be a better solution to this. Can anyone give me an idea? Responses gratefully received!

Hi, i may not be able to provide the perfect solution, infact i am not suggesting a solution here but i just had a hunch. Please check to see if the field you have binded the textbox to allows null values and the error message may mean that firstly it has to update the table and at the same time you are trying to delete the record. When u r trying to update the table it will try for exclusive lock on the record in question and then even for a delete it again has to obtain an exclusive lock. Might be it has got something to do with this...Sorry if it doesnt help you...All the best...vijay

[makai]

set the AllowZeroLength Property to true

see help on AllowZeroLength

you will have to use a TableDef object to write to this field property