Viewing Option Using Checkbox

[Guest]

I currently have a form set with command buttons that open different reports
from a specific query using a macro. The person I am doing this project for
would like the option to be able to view the information in an Excel format
as well. Instead of setting up a sepearate command button that would show
the query results to export to Excel, is it possible putting a checkbox below
the command buttons for EXCEL REPORTS where if they check this box and hit
the same command button, the query results would appear instead of the report
I set up.

If you have any suggestions other than this I'm open to suggestions.

 

[Guest]

Put a condition in your macro or event to run the report or the datasheet
view based on the checkbox.

 

[Guest]

Yes this is possible. You will need to create the check box. Then go to the
VBA coding in the OnCLick event for the command button. Then do a simple if,
end if statement to see if the checkbox is true. If it is excute code that
puts the report into Excel, if it is false excute the code that opens the
report.