Limit Find/Replace to only Find

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if there is a way to hide the Replace tab on the
Find/Replace window?

I would like to limit when a user can attempt a replace by hiding the tab if
they use the Find command from certain fields.

THX!
 
A rather crass way to do it is to set the form's AllowEdits property to No
before the Find.

This kind of thing:

Private cmdFind_Click()
Screen.PreviousControl.SetFocus
If Me.Dirty Then
Me.Dirty = False
End If
If Me.RecordsetClone.RecordCount > 0 Then
Me.AllowEdits = False
RunCommand acCmdFind
Me.AllowEdits = True
End If
End Sub

Other than that, I think you are looking at writing your own Find dialog.
 
Back
Top