how to create a search for box?

[alex188]

hello




Trying to create a search box that searches in my data sheet, In every field (or! Only in a particular field).
Like the default search box in datasheet view form.

I tried to use a macro:search for next record.
It works Only if my data is on the main form! But! My data sheet form is a subform.

And I can not make marco works on a subform. I mean, my text box is on the MAIN form,and I need to search subform.

Thanks to all who can help!

[orange]

Watch this free video tutorial
http://www.datapigtechnologies.com/f...earchform.html

[alex188]

Thanks, but all that I can do, and I could not understand how it solves my problem.
What I want to do is use a macro command "search for next record"

Open another window of the query, that's not what I asked, what I want to do is use a macro to "search for next record," on the subform - that's all.

Thank you very much for the help!

[alansidman]

If all you want to do is find the next record, then here is some code that will do that. Attach this code to the onclick event for a command button. Make sure the command button is situated on the sub form.

Private Sub Command12_Click()
On Error GoTo Err_Command12_Click




    DoCmd.GoToRecord , , acNext


Exit_Command12_Click:
    Exit Sub


Err_Command12_Click:
    MsgBox Err.Description
    Resume Exit_Command12_Click
    
End Sub

Be sure to rename your command button. Mine was named Command12

Alan