after i put earch code in my project :
Private Sub cmdSearch_Click()
search = InputBox("please enter card no", , "")
Data1.RecordSource = "SELECT * FROM waqf WHERE cardno LIKE (""" & "*" & search & "*" & """)"
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