Thanks, however I wnat to use the same form and subform again but apply a different filter if a different button is selected on the menu form, so I dont want to put the code in the Row source of the combo box as it can change. I believe I therefore need the code on the event procedure to open...