Subforms

[sandrao]

I have created a form with two subforms attached. Subform A is
created in the Single Form format and subform B is a continuous
form. Subform A is just for entering information whereas subform B is
mainly for reference.

Both of these form are connected based on the same table. The problem
that I have noticed is that the information that is entered is not be
updated in the subform B. Of course when I close the form and open it
again the information is there. How can I get the form to reflect the
same information.

sandrao

 

[Arvin Meyer [MVP]]

You can requery the 2nd subform in the first subform's after update event.

 

[sandrao]

You can requery the 2nd subform in the first subform's after update event.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com








- Show quoted text -

?.

 

[sandrao]

You can requery the 2nd subform in the first subform's after update event.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com








- Show quoted text -

How do I refer to the subform in the after update code?

 

[Arvin Meyer [MVP]]

How do I refer to the subform in the after update code?
=======================================

Here's the code you need (untested). You will need to use the correct names
where I've put NameOf

Sub NameOfSub1_AfterUpdate()
Me.Parent.NameOfSub2.Requery
End Sub