Yes, you can Seek on attached/linked tables. Simply use OpenDatabase() instead of CurrentDb().<br>
<br>
- CSV<br>
Author, related Access Help topics<br>
Free Downloads at <A HREF="http://www.csvTools.com" TARGET="_new">www.csvTools.com</A>
The previously-suggested solution will not work for the many ZIP codes that serve multiple cities. I recommend the FREE ZIP Lookup routines available at <A HREF="http://www.csvTools.com" TARGET="_new">www.csvTools.com</A> as it elegantly handles this.
The error is that the original SQL statement was improperly delimited. As Area is a string arg, the statement is correctly written thus:<br>
<br>
"SELECT * FROM Table1 WHERE Type = '" & Area & "'"<br>
<br>
...assuming Area doesn't/cannot contain an apostrophe.<br>
<br>
Now...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.