The following code takes a zip code entry in excel and returns the associated County from an Access database. I copied an old .mdb file called TestData.mdb and saved it as an .accdb file called "TestData1". As I now run 2007 rather than 2003

In the following code I made a mistake and left the FROM pointing at the old .mdb file and it returns the County of "Sonoma" correctly when I run it.

Please Login or Register  to view this content.
But when I correct the FROM code to
Please Login or Register  to view this content.
I get crashed out at the .Refresh BackgroundQuery:=False, which points to a coding error.

Where have I gone wrong? All help appreciated.
Harle