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

filtering list boxes combo

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)

ResolvedVersion 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:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.