querying using listbox form

Forum 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

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.08 secs.