Microsoft Access

I need to know how if there is a way to use logic on Microsoft Access. If there is how do you do it. I want to be able to create a drop box on a main form, and the drop box should open the other forms when one is selected. Also, if all of the selections in the dropbox apply how to make them appear.