Hi all,

I have this table that consists of four fields

FileNum
LName
FName
Path

I created a form based off of this table and inserted it as a subform on another form. How can I make the FileNum field hyperlinked to Path??

Basically the form goes like this. A user enters in in the FileNum information in a textbox on the main form and clicks the search button control. The subform "results" gets populated with the results, the path field is not shown.

Any Suggestions?