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.
But when I correct the FROM code to
I get crashed out at the .Refresh BackgroundQuery:=False, which points to a coding error.
Where have I gone wrong? All help appreciated.
Harle
Bookmarks