On my Access db switchboard, I have:
- a Button - "CatReportBtn"
- a Combo box "CatCombo" which has a Row Source of "SELECT CatTable.CatName FROM CatTable WHERE CatType =1 ORDER BY CatTable.CatName;
- Hidden textbox "SelectedCat" with a Control Source of =[CatCombo]
Clicking the button...