Skip to content

Form: Add and Edit Position

Caption: Add and Edit Position
Record Source: Positions
Has Code Behind: Yes
Source: ms_access_files\ruby\Forms\Frm Add and Edit Position.txt

Controls (45)

Control Name Type Control Source
Calibri Label -
Calibri CommandButton -
Calibri TextBox -
Calibri ListBox -
Calibri ComboBox -
Calibri ToggleButton -
Label76 Label -
The Employee TextBox -
Position Effective Date TextBox Position Effective Date
Position Effective Date Label Label -
Training Approver ID ComboBox Training Approver ID
Training Approver ID Label Label -
Position Status ID ComboBox Position Status ID
Position Status ID Label Label -
Second Training Approver ID ComboBox Second Training Approver ID
Second Training Approver ID Label Label -
Organisational ID ComboBox Organisational ID
Organisational ID Label Label -
Job ID ComboBox Job ID
Job ID Label Label -
Pay Point ID ComboBox Pay Point ID
Pay Point ID Label Label -
Reporting To ID ComboBox Reporting To ID
Reporting To ID Label Label -
Employment Status ComboBox Employment Status
Employment Status Label Label -
Organisational Code TextBox =[Organisational ID].Column
Organisational ID Label 2 Label -
Position ID TextBox Position ID
Company ID ComboBox Company ID
Delivery Location ID Label Label -
Termination Date TextBox Termination Date
Termination Date Label Label -
Date Eliminated TextBox Date Eliminated
Date Eliminated Label Label -
Start Date TextBox Start Date
Start Date Label Label -
Job Code TextBox =[Job ID].Column(2)
CloseForm CommandButton -
Last Modified By TextBox Last Modified By
Label138 Label -
Date Modified TextBox Date Modified
Label140 Label -
Position Code TextBox =[Job Code] & \
Label137 Label -

Event Procedures

  • CloseForm_Click
  • Form_BeforeUpdate
  • Form_Close
  • Form_Open
  • Position_Status_ID_AfterUpdate