Update a subform based on a query

[honeypot3]

Hi there

I have a main form which which contains two subforms which are driven from tables. I also have another subform on the main form showing the results of a query which calculates the difference between values on the two tables. How can I make the subform based on the query automatically update when a value in one of the subform is changed rather than having to press SHIFT F9 all the time or close the form and re-open.

Thanks

 

[PHV]

You may play with the Requery method of the query based subform in the AfterUpdate event procedures of the 2 subforms.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[honeypot3]

Hi PHV

I have tried the requery option via macros (as my VB is not good) but when this is run it says it cannot find a field called the name of the query which operates the subform I need updating. How do you get requery to reference the actual query rather than a control?

Sandra

 

[honeypot3]

Got it now PHV - thanks for the direction!

Sandra

 

[neodj]

can u briefly explain how you did this as i am having basically the same trouble

thanks

 

[honeypot3]

Hi Neodj

I went into the AfterUpdate event for the subform that provided the data for the subform run from the query and then wrote the code:

Private Sub Form_AfterUpdate()
[Forms]![Name of main form]![Name of subform needing updating].Form.Requery
End Sub

Hope this helps, Sandra