When entering a criteria in square brackets to prompt the user for the filter, is it possible that all the possible answers appear in a drop-down box rather than you having to remember exact spellings, etc.

Hi Craig

Thank you for your question

It is not possible to do this using parameter queries.

This can be accomplished by creating a custom form with a combo box. You would need to write the code to populate the combo box when the form initializes. You would then need to write the code that runs the query with the relevant parameter.

An exercise similar to this is part of our VBA Excel course

Regards

Stephen