How do i create a macro that will open a form when i open the file? Is it even possible? I just want it to launch when i open the file from my desktop

If you just want to have a particular form open when you load the DB just set Display Form in the Access Options to the relevant form.

I see thanks, but is there a way to have a macro do it or something? Because I'm working on a project and the specifically ask

" Create a macro that will open the main form when I open your file “Bear dog.MDB” "

In your DB create a macro with action OpenForm and formname set {name of mainform}.

Save this macro as AutoExec and it will run automatically when you open your DB.

Thanks, this helped alot

One last questions, how do i save it as an AutoExec?