[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1775
  • Last Modified:

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?
2 Solutions
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
hi fernandoweb,

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

good luck,

fernandowebAuthor Commented:
Many thanks

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now