Run macro when database opens

[torquay]

Hi, I am very new to all of this so please be patient.

When I open my database I would like an existing form to come up ready for entry.

When I open the database at the moment and go to the form for input it goes to the 1st record in the db and then the user has to hit a button to create a new entry.

Hopefully this doesn't seem to trivial

Thanks
Kim

 

[statsman]

A macro named "Autoexec" will be the first thing to run when you open your database.

I will generally have "Maximize" on the first line to open the database in full screen and then tell it to open the switchboard on the second line.

As to your second problem, you should have two screens for each data function.
The first displays records and/or allows edits.
The second (which is pretty much the same as the first design wise) is set to data entry. When you go to the form's properties and select
Data Entry -> yes
The form automatically opens on a new record. All the fields are blank and you can start entering data right away.

 

[torquay]

Perfect, exactly what was needed.
Thank you for your help
Kim