Autoexec in access 2000

[computer_kid1]

How do i make my database automaticaly load up a form when the database is loaded up?

My form is called "Contact Info"

[ScaryBinary]

There are a couple ways to do it. Both involve creating a Macro.

Method 1: Quick and Easy
Create a Macro. In the "Action" drop-down list, chose "OpenForm". Then in the "Action Arguments" section below, enter "Contact Info" in the "Form Name" field. Save the Macro as "AutoExec".

Method 2: Slightly Less Quick and Slightly Less Easy
Create a Macro. In the "Action" drop-down list, chose "RunCode". In the "Action Arguments" section below, enter the name of a Visual Basic function in the "Function Name" field. Make sure you add parenthesis. Save the Macro as "AutoExec". Now, in an existing Module, or a new one, create a new function and name it whatever you typed in your Macro. Add the following code to the function:DoCmd.OpenForm "Contact Info"Note that the function has to be Public (I think). Anyway, the advantage of this method is that sometimes you need to do things that just can't be done with Macros, so you call a function instead.

If you don't need to do anything too fancy, then for sure go with Method 1.

I seem to recall something buggy about one of these approaches, but remember exactly what. Start with the info above and I'll see if I can find anything. If you want to try Method 2, but my explanation isn't good enough, let me know!

[ScaryBinary]

Woops, forgot...

Method 3: Maybe Even Quicker than Method 1
Using the menu, go to Tools > Startup. In the dialog that pops up, select the form you want to automatically display.

[computer_kid1]

I used method 1

it worked cheers, scarybinary