MS Access 97 VBA Question

Parent Database Name: MEMBERS

Fields:
ID Number
First Name
Last Name
Affiliation
Activity

Child Database Name: DUES

Fields:
ID Number
Dues Year
Amt Due
Amt Paid

Relationship:

Each Member can have several Dues Records ie: 1996, 1997 1998, 1999
Index on ID Numbers UNIQUE for each member

Problem:
On a form which also has a sub form showing the yearly dues amounts, I would like to have a command button. When pressed the button should do the following

1) Open the 2 database files
2) Select members where Activity = MA and Affiliation = AV
3) For each of the selected members, add a NEW Dues record where the year = 2000 and Amt Due = $45.00
4) Refresh the form so that this new record appears in the sub form