I have a report that is run through a form. I am filtering out a field using a list box. How would I set up a macro that would ask if what type of format (like e-mail or excel) I want to export the information to. I know if I have a report there is a macro, but how about a form.

Thanks
Rhonda