How would the Pro's do this? (1 Viewer)

[TJPoorman]

OK, so the problem now is that inside your loop you open the form, but once it's open, and the initial filter is applied, it won't open again or apply another filter if there are multiple iterations to the loop.

Yes it will because it is being opened with the acDialog command. This means the loop will not continue until he closes the first form.