how to clear fields after submit

[nabiki]

I have a DB that is used to bring up client information as contact info for clients, after they use that info to ring client i need them to save a record of activity.

So my form has one page/tab with field to add new records to latest contact activity to a table.
I then have the next tab that shows that same table as "previous records"
problem is when i hit submit - the data saves to the table (sometimes twice because i hit submit twice), the form fields just contain the same info and the submitted data is not shown in the subquery on the next page...

Is there a way i can have the data save but then the fields are cleared, rerun the subform query (QRY - Fee Inclusions Subform) and move to the next page/tab

here is the code i have as onclick event procedure
Private Sub Command78_Click()
Dim rst As New ADODB.Recordset
rst.Open "activity", CurrentProject.Connection, adOpenKeyset, adLockPessimistic
With rst
.AddNew
!code = Me.code
!Activity = Me.Activity
!Typeofactivity = Me.activitytype
!Date = Me.Date1
.Update


.Close
End With
Set rst = Nothing
End Sub

[June7]

Why not use a bound form? Reduces chance of duplicate record, no need for the 'Submit' code. Existing records can be displayed on the same form as new record entry. You might like the Split Form introduced with Access 2007.

With unbound form will need to set each control to null to 'clear' the form or close then open form.