Open form in Add only

  • Thread starter Thread starter slam41
  • Start date Start date
S

slam41

I posted this earlier but I was mistaken in what I need. I need this same
situation but in Add only not Edit mode

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.
 
Set the data Entry property to Yes

Or

Open the form with the following VBA code

DoCmd.OpenForm "NameOftheForm",DataMode:=acFormAdd


Or open the form with a macro
Action: OpenForm
Form Name: Name of your form
Data Mode: Add

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