I'm wondering if anyone can give me a hand in writing a counter loop statement. I have recently been given control of a database that needs some revisions.

Here's what I have:

A sample of loans (yep, I work at a bank)
A group of users who review these loans
A form that calculates how many reviews each user should complete each month
Forms into which the users enter review data every month (AKA Review forms)
The ability to populate the Review forms with the loan information

Since each user completes a different number of reviews each month, I have to calculate that number after I pull my sample. (Otherwise, I would have to redo the entire database, and that's just not going to happen.)

Here's what I need:

A way to tell the database to populate the Review forms with the user's name, but only the appropriate number of times without having to go in and change the code every month. For example, Kevin needs to complete 10 reviews next month out of 100 reviews. How do I tell the Review form to assign his name only 10 times? I was told by someone to try a counter loop statement in VBA, but I am not familiar enough with it to make it work. I have tried and tried, but I either get it to populate 1 time or 100 times, nowhere in between!

Thanks for any help you can give!!