Import Specification Does Not Find a Field

[annie52]

I have a command button that imports data from an Excel spreadsheet and puts the data into a new table. If the user changed the spreadsheet (e.g., deleted some columns), Access prompts them for the missing information.

If the user clicks on the Cancel button, I display an appropriate message by trapping the 2001 error. I want to display the same message and prevent further parameter prompts if the user clicks on the OK button. I can't figure out how to do that.

 

[randy700]

One way would be to use a boolean field.
Begin with the field set to TRUE. When the user clicks the OK button, set the value to FALSE.
At every parameter prompt, begin with:
IF booleanField THEN
prompt user.

Randy