When i open my database, i want the main database window to minimise automatically and open my user info form.
So far ive figured how to make the macro to open the form but not how to minimise the database window on opening the database by clicking the icon. Any ideas?

You don't need a macro, use the start up options on tools menu.

thank you i will try that