This is very basic. It clears TextBoxes, Option buttons, and CheckBoxes on a Form.

VB Code:
  1. Private Sub MyResetControls()
  2. '
  3. On Error GoTo Err
  4.     '
  5.     Dim Control As Object
  6.     '
  7.     For Each Control In Me.Controls
  8.         Control.Text = ""
  9.         Control.Value = ""
  10.     Next
  11.     '
  12.     Exit Sub
  13.     '
  14. Err:
  15.     If Err.Number = 438 Then
  16.         Resume Next
  17.     ElseIf Err.Number = 13 Then
  18.         Control.Value = False
  19.         Resume Next
  20.     ElseIf Err.Number = 383 Then
  21.         Control.Clear
  22.         Resume Next
  23.     Else
  24.         Resume Next
  25.     End If
  26. End Sub