For each record in my database, I will have a corresponding Excel Spreadsheet that will contain relevant information about the specific record.
Once the spreadsheet is created, I want it to be linked to the specific access record (via my form).
On a command button, I'm using:
Me!spreadpath = LaunchCD(Me)
This allows me to open the dialog box and search for the specific excel record. The pathway for the record will then go into a control on the form called Spreadpath.
I'm using the control spreadpath as a hyperlink, so all the user does is click it to launch to the excel file in question.
Is there an easier way to do this?