I have an app which already:
displays a list of existing SQL Server records from a table
gives the user the option of adding a record by showing a form with blank fields to be filled in.
I have been unsuccessful trying to find help developing a search option, whereby a window is shown identical to the "add record" window, but the user is invited to enter a partial value in one or more of the fields, then the computer returns a list of only the records which have field values containing that partial value.