Run Query, but prompt for Report

[spudracer]

I've got an update query that will be ran to update a field. That part is simple enough.

What I want to do is prompt the user on whether or not they want to generate a report based on the update query. How would I go about implementing that?

 

[Trevor G]

Create the report anyway and then just use some VBA to display a msgbox to ask if they wish to view the report.

Check this out

http://www.techonthenet.com/access/constants/msgbox_args.php

The arguments could be either

Exit Sub
Docmd.OpenReport etc

 

[spudracer]

I think I've got it figured out, thank you for your help!