Does anyone know how I can evaluate a query while VBA code is executing. I have a series of queries evaluating information. Only upon completion of all information in one query do I want the code to continue. The value of the pivital query (if everthing works correctly) is null. does anyone know how I can write code that can evaluate when the query returns a null value in order to continue evaluating and processing data?