Mike,

I assume your report is bound to the updated table so that wouldn't be to
hard.

Create the update query and save the query.
Create a button on your form and place the following in de code behind the
button (between the Sub and End Sub)

----------------
DoCmd.SetWarnings False '- prevent the message you are about to....
 DoCmd.OpenQuery "your queryname here"
DoCmd.SetWarnings True '- set warnings back on...

DoCmd.OpenReport "your reportname here.."

------------
if you don't want the hassle of the warnings and want to use Jet directly
then place the following in the code:

Currentdb.Execute "your queryname here", dbFailOnError
DoCmd.OpenReport "your reportname here.."

hth