What's the difference between add and edit mode for opening a form in Access?

Hi there.  I've got a database with a particular form which I want to default to a new blank record when it's opened, although someone may decide to then select a record.  However, if I open the form in "add mode" from the switchboard, it doesn't then allow any selection of other records, while if I open it in "edit mode" it defaults to a particular record when opened each time.  It's confusing me as I'm not really sure why add mode isn't letting me do what I think it should be (!)  Is there a way I can get round this?
Who is Participating?
LambertHeenanConnect With a Mentor Commented:
Add mode is intended to only allow new records to be created. So in Add mode the form does not display any older records.

Edit mode allows you to view and edit existing records, and to add new ones.

In order to achieve your goal (defaulting the form to a new record when it opens) set the "Allow Edits" to Yes and "Data Entry" to No. Then you just need a line of code in the form's OnOpen event...

DoCmd.GoToRecord , , acNewRec
aballerasConnect With a Mentor Commented:
hi fernandoweb,

make sure that you "data entry" property in the form is set to NO.

good luck,

fernandowebAuthor Commented:
Many thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.