Kevin has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
Access
When using an Access Form I select a value (in this case a University) from a dropdown list. This produces a Report of information about that University. I would like that report to be created into an Excel file and be saved as the name of the University.
RE: Access
Hi Kevin, thanks for your query. The best way to achieve what you need is to attach a macro to the OnChange event of the dropdown list. This would take the University name, generate the report and automatically export it to a named Excel file. Currently, there is no built-in feature to do this automatically in Access.
Hope this helps,
Anthony
