I have a search form in which a users enters a value to pull up specific criteria...
Private Sub Search_Bttn_Click()
On Error GoTo ErrHandler
Me.Visible = False
DoCmd.OpenForm "Edit - Purchase Orders", acViewNormal, acEdit
DoCmd.Close acForm, "Search - Purchase Orders"
If Err = 2501 Then
' Action canceled - ignore
' Display error message
MsgBox Err.Description, vbExclamation
If a record is found it closes the form and displays the found record in the second form. If a record is not found, it closes the search form and returns a message. But when I search again, the previous text is still in the search box. Is it possible to clear this out?