Re: Requery subforms that don't have a Master/Child relationship

Tech-Archive recommends: Fix windows errors by optimizing your registry

Peter,

In my experience, your design here is very unusual. And based on the information you have given so far, it is more complicated than it needs to be. What is the purpose of the subforms? Why not just base the whole form on the main table, and put the required controls directly onto the tab pages?

It is also not clear what the Requery is supposed to do. Do you mean that the main form has controls bound to the same fields as have been edited in the subforms? And then after the editing in the subform, you want this changed data to be shown on the main form? Would it be possible to give a specific example of what you need to achieve?

--
Steve Schapel, Microsoft Access MVP


Peter Stone wrote:
Novice

I have a form (frmTable) with a large number of pages in tabs. Each page contains a subform (fsubSelect, fsubText, fsubHousekeeping, etc.). All (except one) of the subforms are based on the Main table and so DON'T have a master/child relationship with frmTable.

Is there a way to requery frmTable without having to requery every subform separately?

Thank you

Peter
.

Quantcast