me.requery and me.refresh
What is the difference and when do I use each?
I have a main form based on a query amalgamating three tables with the main form having the autonumber ID and the two minor tables have a numberID equal to the mainform's autonumber.
I click on a button on the main form to open one or other of the minor forms at its related record (IDs related) to enter occasional details in the minor form (which is why it is a minor form and the fields are not part of the main form).
I want to update the totals on my main form following such entries and the fields in the underlying query to recalculate.  at present I use the following expression on the "after update" event
    Me.Requery
    Forms!frmBookAppointment.Refresh
[frmBookAppointment] being the main Form.
It does not seem to work until I close and re-open the main form - should I use recalculate instead of refresh on the main form?
Some of the entries on the minor form affect the calculations on the main form.
Where am I going wrong?
Many thanks
David