Microsoft Access 97 (or higher)

If I understand your question correctly, you want to let the user enter a search STRING and then retrieve in a specific table of your db all records where any TEXT field matches that pattern (in fact, I see no reason why you would search 'TEST' in, for example, the CD ID field).

If this is the scenario, you can build a simple form where the user input the string, and then a query that matches all the text fields with that string (using AND/OR depending on your requirements). For example, youcan use the following Criteria:

Like "*" & Forms![MySearchForm]![StringToSearch] & "*"

Where MySearchForm is the name of the form and StringToSearch is the name of the text box where the user enters the search string.

Also refer to the Access Help: it really is a useful tool.

HTH.

Alessandro

If I understand your question correctly, you want to let the user enter a search STRING and then retrieve in a specific table of your db all records where any TEXT field matches that pattern (in fact, I see no reason why you would search 'TEST' in, for example, the CD ID field).

If this is the scenario, you can build a simple form where the user input the string, and then a query that matches all the text fields with that string (using AND/OR depending on your requirements). For example, youcan use the following Criteria:

Like "*" & Forms![MySearchForm]![StringToSearch] & "*"

Where MySearchForm is the name of the form and StringToSearch is the name of the text box where the user enters the search string.

Also refer to the Access Help: it really is a useful tool.

HTH.

Alessandro

This is pretty simple. Use the form wizard to get started. Create a basic single column form, selecting as the source the table in question (CD).
Once the form is created and opens, click on the designer icon (or VIEW|DESIGN menu). If the properties window isn't already open then click on VIEW|PROPERTIES (make sure the property window is for the Form itsself - if not then click on the dropdown on the toolbar and select "Form") and the on the DATA tab. To the right of DataSource is an arrow andan icon with 3 dots. Click on the 3 dots - the query designer will open. You will see a small window and a grid. The small window is the table and inside it are the fields - either double click on each field so that they appear in the grid, or double click the table window header so that all fields are marked and then click and drag the fields all at once onto the grid.
The last thing do do is add criteria:
On the "Criteria" line under the first field type in something like: [Search criteria]- don't forget the brackets.
Copy this - [Search criteria] - and paste it under EACH field name, on the NEXT criteria line stepping down a line as you go to each field - if they are all pasted onto the same line then you will have 0 results returned because the criteria will use "AND" instead of "OR" for each field search.

Then close the query designer, save, and open the form in form view. You only have to enter the criteria once, but the search will return records found in ANY field that matches the entered query.