Thanks a lot for your help.

I was going off on a tangent which could eventually have caused an abend (array became to large). Only change I made to your suggestion was to assign the "SQL SELECT" to a variable and use that to define the Rowsource property (for legability).

Works when I have data and on empty case.