i'm desperate for help. i'm a new user of access so i'm not familiar with the software. my question is, i have a combo box that contain the category of requestor.When i select the category it will list out the name of the requestor in a list box under the same category only.Now i would like to add the ALL in the combo box that would allow me to select all and list out all the requestor name in the list box without limiting it to a category. I tried the example in the solution databse, but it turn out empty in the combo box.

i really hope that somebody would help me as i had to pass this assignment as soon as possible.......helpppp

domo arigato gozaimasu

Set your combo box's Default value to "All".
Set its Row Source to "All" and the query. Another alternative would be to add an "All" entry to your table, and you sure would get the "All" in your combo box.
Then using the IIf statement to make your list box change due to your selection.