Refresh subform

[corbinap]

I have a subform that I need to refresh or requery to show new total after payments are entered. The subform is based on a query. I have added a button to do the update but I have tried me.requery and me!subformname.requery on the On Click event and neither seems to work. Is there a different way - do I need to requery the query for the subform??? Thanks in advance

 

[Remou]

Have a look here:

http://www.mvps.org/access/forms/frm0031.htm

 

[TheAceMan1]

How are ya corbinap . . .

If Me.Requery doesn't work this shows the button is on the mainform. Try:

[blue]   [subFormName].Form.Requery[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[corbinap]

Thank you - I used AceMan's