Open forum in add mode directly from desktop

A

alex.elliott

Could somebody please tell me how to Open forum in add mode directly
from desktop for the desktop or tell me where I can go for an answer
THanks in advance!!
 
A

Albert D. Kallal

While looking at your database, you can drag the form onto your desktop.

If you click on that shortcut..then eh form will be launched.

If you in design mode set the forms data entry property = yes, then the form
will always open in add mode.

You can also just right click on the mdb file, and go create shortcut. You
then put that shortcut on the desktop. To have your form launch in add mode,
you can create a macro and name it

autoexec

Just use the open form method in the macro...and open the form in add
mode...(macros allow you to do this).

so, either one of the above should do the trick...
 
J

John W. Vinson

Could somebody please tell me how to Open forum in add mode directly
from desktop for the desktop or tell me where I can go for an answer
THanks in advance!!
Click to expand...

I presume that you mean an Access Form (this newsgroup can be called a "forum"
but doesn't have an "add mode...")

If so, open your database. Select Tools... Startup... and select the Form
which you want opened automatically in the "Display Form/Page" dropdown.

To have it automatically open to the new record, you have two choices. You can
set the Form's Data Entry property to true; the downside of this is that it
ONLY lets you enter new data, and will not let you see or edit existing
records. The alternative is to put a bit of VBA code in the Form's Load event:

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub


John W. Vinson [MVP]
 
Top