Filter Listbox using Form

brsawvel

Registered User.
Local time
Today, 01:36
Joined
Sep 19, 2007
Messages
256
do you mean filter a listbox by choosing a criteria from another listbox? or fltering it by the user typing in a criteria?
 
By typing criteria into a text box or selecting preset criteria from a combo box.

Simple Example Attached
 

Attachments

looking at the example i should search the forum for "cascading combo box" there are plenty of examples for this which would probally be a better solution to your form/sub form example.
 
I'm not sure how having "cascading combo boxes" would help.

I don't know if my post was confusing, but attached is a better example of what I want to do. It's a little more complex on the back end I'm sure.

Basically, I want to give a person the option to filter a listbox by any column and value they want.
 

Attachments

Still confused. Do you want to apply more than one filter to the listbox - if so is it an AND or an OR filter?
ie Select fldName = Bella AND fldAge = 12 AND fldcolor = brown OR fldweight > 29
 
It would apply more than one filter.

I.E. -

Code:
SELECT fldAnimal = Dog AND fldcolor = brown

Result:

Record 1. Bailey..........Brown..........3YO..........12LBS
Record 2. Ms. Bailey....Brown..........7YO..........29LBS
 

Users who are viewing this thread

Back
Top Bottom