98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Querying using a ListBox in a form
Querying using a ListBox in a form
Resolved · Medium Priority · Version 2010
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
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.
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 tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |