ACC: Using Variables in the Criteria Row of the QBE Grid

MORE INFORMATION

1. Open the sample database Northwind.mdb (NWIND.MDB in Microsoft Access 2.0 and 1.x).
2. Create a new query based on the Employees table. Drag the FirstName, LastName, Address, and City fields to the QBE grid.
   
   NOTE: In versions 1.x and 2.0, there is a space in First Name and Last Name field names.
3. In the criteria cell of the LastName column, type the following function name:

   ReturnVariable()

4. Save the query as Variable Criteria Query, and then close it.
5. Create a new module and type the following line in the Declarations section if it is not already there:

   Option Explicit

6. Type the following function in the module:

         Function ReturnVariable()
            ' MyVar could also be a global variable set in
            ' a different function.
            Dim MyVar as String
            MyVar = "Davolio"
            ReturnVariable = MyVar
         End Function
   						

7. Save the module as Variable Criteria Module, and then close it.
8. Open the Variable Criteria Query created in step 4. Note that only the record for Nancy Davolio appears.