Hi,

I have a table that is use to store questions(text) for textboxes on a form. I want to delete some questions(record) from the table. Anytime I delete a record from the table, then save, then I go to use the form (I have already deleted the textbox for that particular question on the form). the form give me table maintenace has occured error. By the time I go back to check the table, the record I deleted will still be there. what am I doing wrong.

Pls help. why is the deleted record reappearing when the form is opened?

Don't turn off the warnings and the system should tell you what is wrong with the delete.

my warnings are on and the system is not telling me what is wrong with the deletion.

What method are you using to delete the record? Post the code if you have it.

I am not using any code, I just go into the table and delete the rows I don't need again.

What in your form would create the record? Is it an Access table?

yes, it is an access table and access form. The record is there permanently, but the form gets it's textbox questions from the table, but now I need to change the form, delete some questions from the form, if I just delete the field on the form, it will bring out table maintenance error, but if I delete the question, then delete the field and delete the VB codes that is calling the question, the forms will work. But by the time I close the form and go back again, the question I deleted will be there again.

Maybe it is time to post your db so we can looik at it.