filtering list boxes combo
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Filtering List Boxes with Combo Boxes (Access)

resolvedResolved · Medium Priority · Version 2007

replyReply Fri 28 Nov 2008, 16:02Delegate David said...

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!

For upcoming training course dates see: Pricing & availability

replyReply Mon 15 Dec 2008, 13:44Trainer Jacob said...

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

replyReply Mon 15 Dec 2008, 13:48Delegate David said...

RE: Filtering List Boxes with Combo Boxes (Access)

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

 

Please browse our web site to find out more about
microsoft/access/training/courses and other Microsoft training courses.

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard