Hyperlink Help

[ianbar]

Hi,

I am trying to create a field on a form that allows users to browse for a file and once the file has been seelected a hyperlink is created in the field allowing users to view the linked file. Could someone help me please!

 

[hymn]

1.first make sure you have a hyerlink field in your table
2.on your form ricght click on the hyperlink field
Hyperlink
edit hyperlink

3. browse for your document or whatever and click on it

 

[ianbar]

How do you bring up the dialog box via the On_click event?

 

[bigkeith]

You can create a macro that has an action of 'RunCommand' - with a command of 'InsertHyperlink'. Then just run this macro on your click event.

Keith

 

[hymn]

The hyperlink field that is in your table (say Hyper)
on the form the field called hyper is the field you right click on

in the table the field called hyper?should have its datatype set to hyperlink

 

[ianbar]

Cracked it! Thanks!