One From Update Requery another form

[Mixer1]

Greetings,

I have a form that is simply a containter form for two sub forms. There is
no real relationship between the form and the subs, but rather between one
sub and another.

The sub1 is a continuous from, while the sub 2 is an individual form. Each
of these subs is based on their own query. But both queries are based certain
on the same large table.

So think as sub one General Info and Sub2 as specific.

In On Current of the General sub2 specific, I have code to link this sub to
sub2. So, sub1 serves as an index for sub2.

Data can be added in sub2, but sub1 accepts no additions or edits. Again,
sub1 is sort of an index and a quick look that is not to be edited. All the
editing and adding happens in sub2.

It all works fine. But when someone adds a record in Sub2, I want it to
requery Sub1 so it shows the information just added. As it is, one has to
exit the database and come back in to see sub1 "grow" to show the new records.

So, what would I need in the On Update of Sub2 to to requery and show the
info in sub1 without having to exit and re-enter the main form? Fortunately,
there is only one person who really enters records . . and she can work with
this quirk. But I would like to make it go away if I can.

I'm sure there are better ways to do it, but this works very well except for
this on issue.

Thanks

I

 

[Klatuu]

Use the After Update event of form2 to requery form1

Me.Parent.form1.form.requery

 

[Mixer1]

Bingo. Thanks. Worked perfectly.

Use the After Update event of form2 to requery form1

Me.Parent.form1.form.requery

 

[Klatuu]

Great!
Do others a favor. Rate the post that it answered your question. When
people are looking for answers, they will usually look at the posts with the
green checkmark.