OK, so not that long ago I asked a similar question about getting Excel to open, but I can't seem to apply the same theory on opening a PDF. Everything I found in my searches was written in VB or required the use of fields that are already in use.
So here's my scenario: The current selection in the database is set to open a form via a macro. I want this selection to open a PDF instead as the required form has changed, but we want to cater to the staff and not make them look up the form in a new way or location. I really don't want to redo this form in Access because it loses end-user capabilities (we have to send it to a client). In a sense, the Access database is more of a dashboard for this function.
The combobox is set that if the title from a table is chosen, an action happens from a macro. Is there a macro I can use to open a PDF?
If VB is involved, I will need hand-holding. I am in dire need of a VB education, but it is just not going to happen any time soon.
What I'm hoping to learn is that instead of "OpenForm" as my macro, there's something else I can run which is equally simple. For the previous question I knew that I was looking for "RunApplication," but this is the option that I can't seem to make work. My last resort is adding a new hyperlink button to the form (which is already loaded with fields).
Thank you in advance for your time and attention.
Bookmarks