S.N.Mazumder 0 Newbie Poster

Textbox (text1) is connected to MS Access where the lottery Number is shown. I want to find a number entering in textbox (text2). I wrote code against command1 (ENTER NUMBER FOR SEARCH). But it’s not woking. Please anyone help me.
Code are below:
Private Sub Command1_Click()
On Error Resume Next
Data1.Recordset.FindFirst " Number= " & Text2.Text
If Data1.Recordset.NoMatch Then
MsgBox "No Number found!"
Text2.Text = ""
Text2.SetFocus
Else
MsgBox "Number found!"
End If
End Sub


From
Amit