Access queries

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