Requery a subform from a subform

[mrssevans]

I have battled this for days so I hope someone can help. I have a main form customer FRM and several subforms on a tab form.

I am needing the orders frm to refresh after I enter a payment on the payment frm. These are both on different tabs and I have put the me.requery in almost every on event possible and no luck. Please give me some advice. Thanks, Sam

 

[Shane S]

Hey Sam,

Hope I'm following you good enough to try and help. If Customers is the main form and you need Orders to refresh after entering in Payments then I'm taking that Orders and Payments are both subforms, if that's true then try something like this:

In the Payment field (on the Payments subform) in the After Update property try putting:

Forms![Customers]![Orders].Form.Requery

You could just put a dummy command button on Payments and put the above code and see if it works then decide where you want to place the code after that.

HTH
Shane

 

[mrssevans]

Thank you so much. I will give this a try and see what happens.

 

[mrssevans]

I put the dummy button on their and also put the code on the after update event and after tabbing back and forth twice and pushing the button it works. But is there a more convenient way?

 

[Shane S]

Sam,

Add this and let's see what it does.

Forms![Customers]![Payment].Form.Requery
Forms![Customers]![Orders].Form.Requery

When you say your tabbing back and forth a couple of times then it works. Tabbing back and forth where? In and out of Payment subform?