I am a novice user of Access 2007 and setting this up must be so easy but not for me.
I am trying to design a form in which I specify a “DUES CHARGE” and which when executed will then create new records with these charges in a “DUES” table for all members identified by an “ACTIVE MEMBERS” query. I need this to be automatic once a button in the form is selected since individuals with even less Access skills than I will be using this.

I am looking for any guidance or suggestions with the overall approach to setting this up (append queries, filters, macros, etc). Thank you for any ideas to get me going in the right direction.
Thanks, Steve