'#Deleted' Info on form

[David1234]

Hi,

I have a basic form/subform database, I have been assisted with this slightly by creation of a trigger on SQL. The trigger says that when the main form is deleted, deleted all applicable subform records. This is also true for data entry, when the form is populated, the subform needs to be filled in before progression.

The problem that is being experienced is that when I enter the first part of the information in the form, and then click on the subform to populate, any information already in the form is changed to #Deleted.

Any suggestions on this?

 

[David1234]

Any offers?

 

[speakers_86]

I've read that this is caused by corruption. Perhaps you should make a new blank database and import all of your objects.

 

[David1234]

Tried this action, same result!

 

[spikepl]

It sounds like your trigger is too trigger-happy and fires as it pleases. And it begs the question: why create a trigger to maintain referential integrity? In a trigger-free world, such things are normally taken care of by the cascade delete setting in the relation.