Search not showing results

[smogsy]

Hi all,

I have a form just for searching my database i created a bound text box which is bound to to Scriptname & want it to search Scriptname information in just 1 table & Display the results.

My Code executes with no Errors what so ever, however im not getting any results displayed. Can you explain how i can do this?

ScriptName = Text Box & ScriptName is also field i want to search

      If IsNull(ScriptID) Then
      MsgBox "Please Enter An Scriptname"
      End If
 
      If IsNull(Me.ScriptName) = False Then
          Me.ScriptName.SetFocus
          Me.Recordset.FindFirst "ScriptName='" & Me.ScriptName.Text & "'"
         
         Me!ScriptName = Null
  If Me.Recordset.NoMatch Then
             MsgBox "Account Number Not Found", vbOKOnly + vbInformation, "Sorry"
             Me!ScriptName = Null
         End If
     End If
End Sub

 

[RuralGuy]

You need to include all of the code involved from Private Sub...to...End Sub.