Skip to content

Form: Add and Edit Users

Caption: Add and Edit Users
Record Source: DatabaseUsersSales
Has Code Behind: Yes
Source: ms_access_files\emerald\Forms\Frm Add and Edit Users.txt

Controls (25)

Control Name Type Control Source
MS Sans Serif CommandButton -
MS Sans Serif ToggleButton -
Label76 Label -
Lead Type Label Label -
Label17 Label -
Label18 Label -
Department Label Label -
Label Role Label -
Email Address Label Label -
Cell Phone Number Label Label -
User ID TextBox User ID
Username TextBox Username
Last Modified By TextBox Last Modified By
Date Modified TextBox Date Modified
LEVEL ComboBox LEVEL
User Password TextBox User Password
Department ComboBox Department
Role ComboBox Role
Email Address TextBox Email Address
Cell Phone Number TextBox Cell Phone Number
CloseForm CommandButton -
RecNum TextBox =GetXofY([Forms]![Frm Add and Edit Users])
Label24 Label -
NewRecord CommandButton -
Label29 Label -

Event Procedures

  • CloseFOrm_Click
  • Form_BeforeUpdate
  • NewRecord_Click