Requery Form data

[niccig]

I have a form based off a query. I have a button that I want the user to click when they've finished adding in new records in the sub form. This is to requery the main form so the SumofHours is recalculated (this is in the form's query). The on click for the button is Me.Requery which recalcualtes the hours, but it takes you back to the first record, I want it to update and stay on the current record. Any suggestions?

 

[Jon K]

Take a look at Pat's post this thread:-
http://www.access-programmers.co.uk/forums/showthread.php?t=70818

.

 

[niccig]

Thanks

Thanks for this. The button is on the main form and not the sub form so Me.Form.Requery worked!