> Can you change it around to return the PonID as a recordset? Then you > can access it like a recordset. > Gladly. Any suggestions? I'm not fussy about method, just results. What I'm trying to do is avoid making two sequential calls to the db, one to insert, then going back to read the max value. joel