I have read that it is possible using VBA to access a file from text boxes. I have a requirement to access files (source and image) that are placed into a folder that I named "attachments". I can hyperlink to them, and I attach them to database. Unfortunately, I have to move the data periodically and all links are broken, and the database grows too fast when attachments are created. Ideally, I would like to post the filename into a text box and the current repository folder path into a separate text box, and then be able to open the file for access (perhaps using an action button).
Thanks in advance,