Search

[whitestone]

I need to set up some kind of search facility which is accessed from a button in a form.

I would like the user to be able to type in bit of info and be able to bring up the record in the form view. What is the best way of doing this?

Thanks

Ben

 

[Mile-O]

On the click event of your button:

DoCmd.OpenForm "YourForm", acNormal, , "[YourField] Like '*" & Me.txtYourTextBox & "*'"