i would like to have a control button that would take data from a specific field and use it as a hyperlink so that i can link up office documents.

thanks in advance!

For a Command Button got to

Format
HYPERLINK ADDRESS

and enter the hyperlink address

You could also assign the value in code

You can also add a Hyperlink Subaddress i.e a 'label' on a HTML form. However a small bug means that the SUBADDRESS does not always work with all browsers notably IE 3.0. It does appear to work with Netscape 3.0 and higher and also IE4.0 and higher. May or may not work with other browsers

Hope this helps
Trevor from Accesswatch.co.uk

Addendum to above
I have just checked my documentation and it Appears that the Hyperlink SubAddress SHOULD work with Office Documents, Netscape 3.0 or higher and IE 4.0 and higher.
Hope this help
Trevor from Accesswatch.co.uk