manual delete leaves delete

[chirpyform]

I have overridden the delete mechanism in a form (because of complicated relationships between the tables) in the On_delete function (cancel = true) so that I can do "DELETE FROM TABLE X WHERE ...". At the end however the screen has #delete in all the areas where I had data.

I have tried requery but I cannot do it in this function and I don't want to have to close and reopen the form or goto another object which is used only to do the requery.

Can anybody give a clean option to this problem....

Many thanks Chris

 

[TheAceMan1]

How are ya chirpyform . . . . .

The On Delete event is just not the right place to requery.
Move requery to the [blue]After Delete Confirm[/blue] event.

Be sure to read about it in VBA help so you understand whats going on. In fact, all the delete events should be read.

See Ya! . . . . . .

 

[chirpyform]

Great idea theAceMan1 unfortunately as I do "Cancel = true" I'm not sure that this function is relevant....


Chris
PS MY VBA Help is not working

 

[TheAceMan1]

chirpyform . . . .

Yes you did say you were setting Cancel to True. So if Requery does'nt remove #deleted, need to see your relationships (complicated as you say) and wether or not cascades have been selected. Hard to tell otherwise . . .

See Ya! . . . . . .