PDF file

[combine21]

I am wanting to be able to insert a link to a PDF file in some database entries in a form. Is this possible without making every entry a hyperlink?

[ketbdnetbp]

Yes, you could try something like...

Place a new Button on your form

Then, in FORM'S, VBA Current Event, add -

Private Sub Form_Current()

'Add in your own error handling
'Set PDF file Location variable
dim st1 as string
'If the file's location is in a field on your form, i.e. in recordsource
st1 = Me![YourPDFFileLocationControl'sName]
'then, Assign variable to button's HyperlinkAddress Property
Me![YourButtonName].HyperlinkAddress = st1


End Sub

Thereafter, once you click the button, it should open the appropriate file.

If the PDF's file location is not a field in the form's recordsource, let me know as there are several ways to put it into the stated variable.

Hope this helps,

Jim