I have used the GetFile() function in Fox6. I used it in the context that when I click a button on my form the Open File Window appears so that the user can then select the file that they want. Then I read the path of what they chose into my database.

I am trying to duplicate this in VBA in an Access application (before I get crushed for using Access, let it be known that I am helping a friend with this functionality, it is not my App). The research I have done points me in the direction of using the Get function in the FileSystemObject. Could someone please assist me in duplicating what I have done in Fox to VBA code in Access.

TIA

Wes