How do I solve this MS Access problem?

I would like to create a switchboard in MS Access that allows me to specify multiple criteria through a dropdown box and then subsequently display the output. For example I would like to specify "fruits" from a list of sets and "red" from a list of colors to give an output like apple, . It seems to me like the MS Access switchboard can only display a single form output upon the user clicking a on. Can any expert out there point me in the correct direction? Thanks!