Refresh records between subforms

[IpeXeuS]

Hello,

I've one subform related question. Ok, I got main form wheres 2 subforms (form view/table view) in different tabs. What I try to complish here is that when I delete some record in other subform (table view), that same detail will automatically delete in other subform (form view) as well.

I manage to delete record from other subform, but there's still that record in other subform and there's "#Removed" text in every fields in that subform. Is there another way to do this, so those "#Removed" texts dont appear at all?

All advices are welcome and grateful approciated.

(Sorry about my english grammar )

 

[boblarson]

Set a requery for the other subform in the afterupdate event of the one that got updated. So, if you have two, then put a requery into each on their afterupdate, but it would be referencing the OTHER subform.

So, if I have a main form named frmMain

And a subform named sfrm1

and another named sfrm2

Then, on sfrm1's afterupdate event I would put Forms!frmMain.sfrm2.Form.Requery and on sfrm2's afterupdate event - Forms!frmMain.sfrm1.Form.Requery

 

[IpeXeuS]

Thanks for the thip man, approciate that.