[RESOLVED] Hyperlinking one field with another in Access
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?