i want to use vlookup how to do it
Vlookup is an Excel function. You can try DLookup: http://access.mvps.org/access/general/gen0018.htm I'm going to split this off to it's own thread since it's unrelated.
Paul (wino moderator) MS Access MVP 2007-2019 www.BaldyWeb.com
Forum Rules