Can anyone help me? I have created a query in Access 2000 which when I first click on the query I have to enter a desired entry within a data field. How can I customise the expression to allow only a partial entry using wildcards rather than having to type in the exact wording and is it possible to have a drop-down list with all available answers ?
Any help much appreciated.

Create a form with a Command button and a Combo box. Have the Combo box list the values that you want the user to select for the criteria. In the Query put this in the Criteria line under the column you want:

[Forms]![FormName]![ComboBoxName]

Now have the Command button open the Query... When the user select a criteria from the Combo box and they click the Command button the will see their selected data.