Setting Parameters for Search Conditions 

Use

In the Visual Query dialog, you can set parameters for search conditions for database queries. When you execute the database query a dialog window then opens in which you must enter a value for the parameter.

Procedure

1.       When you create a search condition, insert square brackets in all the places you want a variable entry to be possible.

2.       If you want to formulate a prompt for the dialog window, enter this prompt within the square brackets.

You can set parameters for the search condition for the Order_No column of the table Purchase orders as follows:
=[order number:]