add records in list box question

[Walter]

I have a db for a church with the tables:
tblMembers; MemberID, FirstName, LastName, Etc.
trelComMbr; ComMbrID, CommitteeID, MemberID, Date
tlkpCommittees; CommitteeID, CommitteeName

I would like to create a form with 2 list boxes and add
and remove buttons to manipulate the data. The left list
box will open with the list of members(row source = SQL
On Load) and the right list box will show existing
committee members if any. In order to add or remove
members I would need an Append Query and a Delete Query
which would be run by a command button on the form,
correct? My idea is one form which will get the
committee name and date from a dialog box on opening. In
order to update committees, the dialog box would open and
you would choose a committee name, set a date and then
click a button which would open the form. The
Append/Delete query would add/remove the MemberId to the
record and then requery the right list box to show the
change. I can't get a grasp on how to define the queries
and what all needs to take place to accomplish this.
Questions:
Should the dialog box close when the other form opens or
does it need to stay open to make it's data available to
the query?
How do I grab the data from the dialog box?
Is the highlighted name in the left box going to be
picked up by the query?
If not, how do I choose this name(MemberID) for the query
to use?
This is my first experience with action queries. I have
tried to create an append query to add records to the
table but so far have been unsuccessful. Any guidance is
appreciated.
Thanks,
Walter