Thanks in advance!! I really have been out of VBA and Access for 5 years and have lost some of my edge. I need to loop a macro from a Function until a field in the Table [MakeRatio]![ASK] reaches 0. I can take care of the counting within the macro but I need to call a function from RUNCODE in a macro.