Writing to table and closing form

[John]

I am trying to write info to a table when the user clicks
the agree but and then another form opens. What I want is
when the user clicks the agree button it copies logon info
to the table, opens a new form, and then close the
original form.
I need some help with a confidentiality form I have when
users access the database. The form has a subform that
captures the network logon of the user and also has the
date/time they opened the database. The form also has an
Agree and Disagree button for the user.
How can I write that info to a table to keep track of
users in the database. I don't want to set up separate
user accounts, it will be too much of a hastle to do that.
Also, how do I close the confidentiality form when the
user clicks agree and then open the other form. I have it
coded so it opens another form but the confidentiality
screen stays open in the back ground.
Any suggestions will be very helpful.

TIA,

John