I am trying to automate importing data from a text file to a table but the text file changes each time. I want to use an open common dialog box from a form to allow the user to browse and select the text box and then save the path in a variable. I can get the dialog box to open and allow the user to select a file, but when you click on 'OPEN' command button, I get runtime error 20476 - Method 'ShowOpen' of object '1CommonDialog' failed. Can anyone give me suggestions on how to get past this error?

Check Litwin's Access 97 Developer's Handbook. It has code and an exlanation for utilizing the common Dialog.