How to link a list in combo box with queries to filter the specific data?

[afirooz]

Dear All,



I need help on filtering data based on a list in a combo box. For instance I am developing a Leave Tracking Database and have differnt types of leave, I want the leave information to be filtered when I chose the leave type, such Annual Leave, Sick Leave and so forth each type of different values and the data entry should be based on the sepefic leave type.

Regards,


Ali Khan

[June7]

You can use the intrinsic search/filter tools on ribbon or right click shortcut menu. Or you can write code (macro or VBA).

Review http://allenbrowne.com/ser-62.html