Update Current Record

I am a relative Newbie so if my question sounds stupid, bear with me:

I have a form with a subform linked to a query.

On the subform i have a checkbox[Recieved] and when checked adds a date to
another field [Year] on the subform which in turn updates the record in a table[Orders].

I then click a command button on the form which runs a crosstab query based on the
updated fields in the table [Orders].

This works well except for the last record ammended which does not update the [Year]
field in the table [Orders]. When the command button is clicked it is still the current
record in the subform.

clicking another record in the subform solves this or closing the form and reopening it before running the crosstab query.

Is there an easier way to automate the update? So that the user does not have to select another record first.