Open form in Add only

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.
 
J

John Spencer

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
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top