1. Have the hyperlink in a text box
2. Add a command button to the form.
3. In the forms 'On current' event set the button's hyperlink property to be
the value of the text box.
This seems to work OK but gives little control of how the document is opened but my be Ok for your requirements.
Create a label. Put whatever text you want in it.
Right click it and choose "Properties"
Third line down, under the ALL tag, is the "hyperlink address" field.
Put a DLookUp there that references the right spot in the table.
I've tried all of these ideas but i've not had any joy yet. the zip file works for the first record in the DB but when i go to the next one it kicks out an error. i have about 3000 records in the DB, each with individual URL's. i need to be able to go from record to record and access the URL. Of course i could copy and paste but i really dont want that!
check out this attachment, this should be clearer. there are 3 records in there. double click the url in the first record and it open fine but in the second and third it contains an error
You didn't say it was your db that was not working. When you reply let the poster know what is happening. I thought it was my db that was giving you trouble and I am tring to find the fault.
I have make a couple of changes, and as I have given it another name it will not over write your when you unzip it.
The changes are:
Your hyperlinks are blue and underlined.
When you double click the hyperlink the record is saved before it tries to open the link.
The form will maximize when opened.