detecting the openform mode in VBA (1 Viewer)

[bertiespiv]

Seems other people are trying to acheive the same thing but from different angles. i also am combining an ADD/Amend form to avoid code duplication etc. I am trying to do it by simply detecting in what mode from the switchboard my form has been opened ADD or EDIT. Anybody any ideas on how you can determine in what mode the form has been opened?

cheers
BS

 

[ajetrumpet]

You can check these properties of any form in code:

*allow Additions/Edits/Deletions

The value of those properties are either TRUE or FALSE. Example:

if forms("formname").allowadditions = FALSE then
  msgbox "The form is open in EDIT mode"
else
  msgbox "The form is open if ADD mode"