I didn't notice on one of your original posts that you added a single quote between double quote after lngPK2
On both!
Paul (wino moderator) MS Access MVP 2007-2019 www.BaldyWeb.com
Forum Rules