Hi Sebastain,
*** Answered my own question ***
I'm using Access 2000 and the FileDialog object will not work with it, you need to be using Access 2002 for it to work. From another newsgroup, I now see that you must use the API to perform this function. Here's a link to some sample code:
http://www.mvps.org/access/api/api0001.htm
Darn the luck, the FileDialog option sure looks a lot simpler.
*****************************************************************
Thanks for your comments. I'm close, but not working yet. I found the Microsoft Office 11.0 Object Library and clicked on it and inserted the code you suggested.
When the code runs, I get a message "Compile Error - Method or Data Memeber not found", and FileDialog is hilighted in the code. I think my machine is not really accessing that library, although, it is still checked off when I look at the References again.
Do you have any idea of what I might need to try to get the code to really 'see' that Object Library?
Thanks,
Lisa
Edited 1 time(s). Last edit at 01/11/2006 03:01PM by Lisa Anderson.