In the thread regarding the Conc() code put together by Jon K (http://www.access-programmers.co.uk/forums/showthread.php?t=64611), you mentioned that it worked perfectly in Access 2007 once you updated the VBA ADO references. Could I get a look at your modified code? I really liked the Conc() function in a couple of places in my 2003 database and want to continue using it, but my programming knowledge is still very limited, so I wasn't sure how to modify it myself.