after i put earch code in my project :
Private Sub cmdSearch_Click()
Dim search
search = InputBox("please enter card no", , "")
Data1.RecordSource = "SELECT * FROM waqf WHERE cardno LIKE (""" & "*" & search & "*" & """)"
Data1.Refresh
End Sub
-------------
the search working but appear problem that when i click on search buttom he give me the object that iwant then i want back to all data (in dbgrid) in forms i can't only data of search appear that make me close project and start again ,, please help me friends
((if you don't full down you willn't come up)) thank u all