Forum home » Delegate support and help forum » Microsoft Access Training and help » Access queries
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access queries
Resolved · Low Priority · Version 2007
Reply Tue 24 Jun 2008, 16:14Delegate Craig said...
Craig has attended:
Access Introduction course
Access Intermediate course
Access queries
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.
For upcoming training course dates see: Pricing & availability
RE: 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
|