Hi, I would like to put a button on a form for a user to design a new query...on click they can go to design view of a query...can anyone help me out with this please ? I'm not very good on VB Code (understatement)Thanks.

You should be able to skip the VBA work by using the button wizard. You can choose a command from the wizard to open query. Otherwise, you can use a macro, assigned to OnClick for the button, that will open the query.