In order to create a "browse" button I've used the code in http://www.mvps.org/access/api/api0001.htm
The button works perfectly well.
However, what I want to do is to asign the chosen path to a specific text box (with it's hyperlink property set to true).
Using something like
Me![Textboxname]=strInputFileName
the text box is given the correct path, however the file doesn't open when I click on the hyperlink.
In fact, when I cut the path from the textbox and paste it again, what I get is...
C:\correctpath## (note the two # in the end).
What am I doing wrong?
The button works perfectly well.
However, what I want to do is to asign the chosen path to a specific text box (with it's hyperlink property set to true).
Using something like
Me![Textboxname]=strInputFileName
the text box is given the correct path, however the file doesn't open when I click on the hyperlink.
In fact, when I cut the path from the textbox and paste it again, what I get is...
C:\correctpath## (note the two # in the end).
What am I doing wrong?