i have tried this before, but foolish i forgot about the rest of the
form and was thinking that when all rows were hidden there was
something wrong with my process, but its actually functioning exactly
how one would expect.

Thanks, i doubt i would have realized that it was working before
without you posting exactly what i had previous tried