I have a form that contains a combo box which i have called School. The combo box contains a list of school names, with a unique identifier for each school. I would like to create a command button which will execute some code and create a pass through query just for the school that has been chosen in the combo box. How would i go about writing the code? i dont have much experience of VBA and never really had to create pass throughs before. Im assuming i would need to create a function in the on click part of the command button. Can anyone help???