Pulling fields to create a file path? HELP!

[TMSpd]

Hey Guys, Im trying to create a form to store our orders on at work. We scan our orders in and then I want to attach them to this database so they are easily accessable. My first attemed of using OLE's failed as the database got too big after 150 entrys.

My latest attempt I want to use a link to the .pdf file. But I dont know how to make a field that will automatically generate the link from the customer name and part number. the file path is something like c:\scanned drawings\[customer name]\[part number]. I cant use VBA so I have to do things long hand. Can anyone help me with this issue.

Cheers



TMS PD

[June7]

If you can't use VBA, what are you doing? Do you want to build a hyperlink string that will open the pdf document? This article describes hyperlink structure http://office.microsoft.com/en-us/ac...005188817.aspx

I don't know if hyperlink built by string concatenation in textbox ControlSource will act like a hyperlink. I don't remember much about 2003. Does it have a Hyperlink field type? Does textbox have IsHyperlink property?