refresh all (sub)forms automatically when editing a field on one subform

[Bospeentje]

I have a form with several subforms. When I edit a field on one subform (or delete a record there), I want all (sub)forms to refresh automatically and inmediately.
I tried to do this by calling a me.refresh Function (AfterUpdate) on the main form. This works, but NOT when I delete a record on the subform... it seams that Access doesn't see this as an (After)Update.
Please, any suggestions to get this work?

[burrina]

Your going to have to refer to the subform(s) and then refresh them.
HTH

[RuralGuy]

FYI: A Requery is required in order to refresh the recordset after a delete.

[Bospeentje]

Hmmm... question is: how and at which point do I refresh/requery the forms/dataset?
I want all forms (whole screen) to refresh automatically after editing or deleting a field (record) on a subform, without any specific keystrokes for the users...
Seems to me I have to add a function or code to the specific field on this sub-form.
(help!)

[RuralGuy]

Create a button on the Main Form and use the click event to add code that Requeries each of your SubForms. Once you have it performing as desired you can delete the button and just call the procedure from any AfterUpdate event you want. Here's the syntax for referring Form elements in Access: http://access.mvps.org/access/forms/frm0031.htm

[Bospeentje]

Tnx RuralGuy, I have tried that and indeed it works fine... but not when I delete a record on a subform. It appears that Access doesn't see that as an update event, so the AfterUpdate event can't be called.
If only I knew how to call this code when deleting a record.

[RuralGuy]

How are you deleting the record?

[Bospeentje]

The subform is a continuous form with just one field (record) and selection buttons. I delete a record by selecting it with the selection buttons and simply press delete.
So after this deleting, all forms should be refreshed.

[RuralGuy]

Have you tried calling your Button code from the AfterUpdate event of the SubForms? If you could provide a sample db I could play with it a bit.

[Bospeentje]

I have called a me.refresh function on the main form, at an AfterUpdate event in the record on the subform. This only refreshes every form after editing the record on this subform, not after deleting a record... if you would try and figure this out, I would be very gratefull.

I have attached a test db.
The main form is "Frm_medewerker"
The subform in question is "Subformulier Tabel_medewerker_producten", the field "product"

[Bospeentje]

Oh btw... in this db the refresh button on the main form still has a refresh macro attached to it.

[RuralGuy]

After fixing some of the language issues, when I run the Frm_medewerker and select a record on the Subformulier Tabel_medewerker_producten and hit the Delete key on the keyboard, the SubForm displays accurately. Maybe I'm doing something different than you.

[Bospeentje]

When you say "the Subform displays accurately" you mean the sub-form Subformulier Qu_opleidingen_bij_producten_en_niveau is updated automattically???
Because that's what should be happening, but still doesn't work on my computer. I still need to hit the refresh button on the main form to refresh all subforms. Even tried it with your attached file with the fixed language issues.

Would it be possible that this is an Access setting or something like this?!?

[jgitaunjoroge]

can you translate the database into English

[RuralGuy]

I'm sorry Bospeentje, it looks like I just dropped this thread completely. Did you ever resolve your issue?