Forum home » Delegate support and help forum » Microsoft Access Training and help » Querying using a ListBox in a form
|
|
|
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. |
Querying using a ListBox in a form
Resolved · Medium Priority · Version 2010
Reply Fri 1 Apr 2011, 15:08Delegate Matthew said...
Matthew has attended:
Access Introduction course
Access Intermediate course
Querying using a ListBox in a form
I am trying to use a ListBox in a Form in order to filter the records shown in a report via a query but I can't find out how to use the selected items in the ListBox in the Criteria builder in the Query.
Matthew
For upcoming training course dates see: Pricing & availability
RE: Querying using a ListBox in a form
Hi Matthew,
Thank you for your question.
As far as I am aware, you cannot do this through the Query Builder in Access. You need to write VBA code which is beyond the scope of the forum in this case.
At lunchtime I will check with another colleague and if he has any alternatives I will email you again.
I have however included a link with some sample code.
http://www.fontstuff.com/access/acctut11.htm
I hope this helps.
Regards
Simon
Mon 11 Apr 2011: Automatically marked as resolved.
|