deleted records reappering

[kasa74]

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?

 

[RuralGuy]

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

 

[kasa74]

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

 

[RuralGuy]

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

 

[kasa74]

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

 

[RuralGuy]

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

 

[kasa74]

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.

 

[RuralGuy]

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