filtering list boxes combo

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Filtering List Boxes with Combo Boxes (Access) | Access forum

Filtering List Boxes with Combo Boxes (Access) | Access forum

resolvedResolved · Medium Priority · Version 2007

David has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Filtering List Boxes with Combo Boxes (Access)

how can I filter the records displayed in a list box by choosing values from a combo box

eg list box displays order number, customer and value. the combo box (on the same form) shows the different cusomters.

list box is called "lstTickets", combo box is called "cboCustomerFilter" and the form is called "Review Tickets".

thanks!

RE: Filtering List Boxes with Combo Boxes (Access)

Hi David

Firstly our apologies for the dealy in getting back to you.

As your post does involve something specifc that you are trying to achieve in a database of yours, it would help if you can send through some further information for us to review.

For example:
Screenshots of the actual boxes, list of database objects, and if possible a sample of the actual database.

We can then confirm if we can assist, and if so there maybe some development time that we need to set aside and which will have a cost.

If you wish to proceed, please let me know.

Kind regards

Jacob

RE: Filtering List Boxes with Combo Boxes (Access)

it's alright - i've bought a book and worked out how to do it myself.


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Server loaded in 0.08 secs.