I used API call to open up a file dialog window, where you can choose a file and the path to it is stored in a hidden text box.
My problem is that the path is stored this way: "C:\MyFolder\MyPics\MyPic1.jpg" and it should be like this: "..\MyPics\MyPic1.jpg", so that they can be displayed even if someone saves the database in different location.
This is the code that gets the picture path:
Dim strFilter As String
Dim strDefaultPath As String
strDefaultPath = Application.CurrentProject.Path
Me.txtPicPath = GetOpenFile(strDefaultPath, "Find Picture..")