Forms do not refresh after deleting record

[stopher]

Is the record getting deleted ok?

I would comment out the Setwarnings False line until you have things straighten out.

 

[boblarson]

What do you mean if you move back to Developer's Mode? That doesn't make sense to me. Enabling code (or putting the database in a trusted location so you don't have to click the button each time) is simply just enabling or disabling certain actions deemed to be potentially dangerous by Microsoft. Things like being able to delete tables change values, etc.

If you are wanting to requery a subform from another subform's code it would be

Me.Parent.SubformControlB.Form.Requery

 

[Farnham]

Is the record getting deleted ok?

I would comment out the Setwarnings False line until you have things straighten out.

Yep, the record is getting deleted okey every time. And the subform from where the deleting is being made is presenting the correct information. But, the other subforms still refer to a non existing record, and that causes the problem.

 

[boblarson]

Want to solve this pretty quickly (now that it has gone on and on and on)? Upload a copy of the database and I'm sure we can have the solution in a very short time.

 

[Farnham]

What do you mean if you move back to Developer's Mode? That doesn't make sense to me. Enabling code (or putting the database in a trusted location so you don't have to click the button each time) is simply just enabling or disabling certain actions deemed to be potentially dangerous by Microsoft. Things like being able to delete tables change values, etc.

If you are wanting to requery a subform from another subform's code it would be

Me.Parent.SubformControlB.Form.Requery

By developers mode I mean when I start the database by holding left shift, and user mode is when I just click the dile without shift and therefore hide some part for the user.

Okey, I will try the code you wrote as soon as I can. Thank you for your tip!