Draneer Code Library

Find Utilities - Handling the Records Browser FIND processes.

Typical Usage:
 - The cmdClear_Click() subroutine must be added as the click event for a button typically called [Clear] on the browser form.

Module Code
=========================================================================================================
Private Sub cmdClear_Click()
  Dim Dran_ctrl As Control
  '---- Clear any controls tagged "Find"
  For Each Dran_ctrl In Me.Controls  '---- "Me" is the active form.
    If Dran_ctrl.Tag = "Find" Then
      Dran_ctrl = Null
    End If
  Next Dran_ctrl
 
'---- Optionally display all records.
  DoCmd.ShowAllRecords
End Sub

=========================================================================================================

Back to ...
Code Library Menu