Sorry, I think I've not made it clear/I'm getting very confused.
Our current report system, once split, offers the user a list of buttons linked to various reports. When they click the button, a second form opens with options (such as date, venue, ClientId) that the user selects from drop-down lists on the form. Once they click run, the report the form is linked to opens. The vba I posted above tends to do this.
For this one, I want a button that, once pressed will open Form1, then I can select the clientId/username from the drop down box created on Form1 and it'll run the Report "Merged1"
Am I thinking something different?
Apologies for confusion, J