Opening form in Edit only

[slam41]

I need to create a custom switchboard. I also need a feature that is seen
when you use switchboard manager, which I don't want to do. I know how to
insert a command in the form to open a form but I need the form to open in
edit only. I know that there is probably a macro that can be written but I
know very little about how to write and use macros.

 

[Marshall Barton]

I need to create a custom switchboard. I also need a feature that is seen
when you use switchboard manager, which I don't want to do. I know how to
insert a command in the form to open a form but I need the form to open in
edit only. I know that there is probably a macro that can be written but I
know very little about how to write and use macros.

I think all you need to do is open the form in design view
and set the form's AllowAdditions and maybe AllowDeletions
properties to No.

 

[John Spencer]

If you want to be in EDIT mode every time you open the form, then set
the form's edit property to Yes.

If you want to be in EDIT mode only when you open with a button, you
need a line like the following in the VBA code attached to the button
DoCmd.OpenForm "MySpecialForm",DataMode:=acFormEdit

or if you want to use the comma syntax

Docmd.OpenForm "MySpecialForm",,,,acFormEdit

If you want to use a MACRO then the action is
OpenForm
and you set the Data Mode to
EDIT
for that action.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================