Form: Add and Edit Sales Brief
Caption: Frm Add and Edit Sales Brief
Record Source: Sales Brief
Has Code Behind: Yes
Source: ms_access_files\emerald\Forms\Frm Add and Edit Sales Brief.txt
Controls (173)
| Control Name | Type | Control Source |
|---|---|---|
| Calibri | Label | - |
| Calibri | CommandButton | - |
| Calibri | TextBox | - |
| Calibri | ComboBox | - |
| Label76 | Label | - |
| PrincipalLabel | TextBox | =[SubFrm Sales Brief Principal].[Form]![Principal] |
| Principal ID | TextBox | Principal ID |
| Sales Brief ID | TextBox | Sales Brief ID |
| Date Created | TextBox | Date Created |
| Date of Brief_Label | Label | - |
| SubFrm Sales Brief Principal | Subform | - |
| AddPrincipal | CommandButton | - |
| Solutions Architect | ComboBox | Solutions Architect |
| Solutions Architect_Label | Label | - |
| Key Account Manager | ComboBox | Key Account Manager |
| Relationship Manager_Label | Label | - |
| Sales Manager | ComboBox | Sales Manager |
| Sales Manager_Label | Label | - |
| How Lead Generated Combo | ComboBox | Channel Partner |
| How Lead Generated Text | TextBox | Raizcorp Management (Lead Generated) |
| How Lead Generated | ComboBox | How Lead Generated |
| How Lead Generated_Label | Label | - |
| Contract Type | ComboBox | Contract Type |
| Contract Type_Label | Label | - |
| Contract Duration | ComboBox | Contract Duration |
| Contract Duration_Label | Label | - |
| Contract Duration Other | TextBox | Contract Duration Other |
| Contract Duration Other_Label | Label | - |
| SubFrm Sales Brief Contract Numbers | Subform | - |
| Contract Start Date | TextBox | Contract Start Date |
| Label100 | Label | - |
| Label101 | Label | - |
| PrincipalName | TextBox | =[SubFrm Sales Brief Principal].[Form]![Principal] |
| Label323 | Label | - |
| Project | TextBox | Project |
| Project Label | Label | - |
| Contract FYE | ComboBox | Contract FYE |
| Contract FYE_Label | Label | - |
| Verification Year | TextBox | Verification Year |
| Verification Year Label | Label | - |
| SubFrm Sales Brief Principal Priorities | Subform | - |
| Entity Contracted | ComboBox | Entity Contracted |
| Entity Contracted_Label | Label | - |
| Contract Payment Terms | ComboBox | Contract Payment Terms |
| Contract Payment Terms_Label | Label | - |
| SubFrm Sales Brief Finance Special Payment Terms | Subform | - |
| SubFrm Sales Brief Finance Invoice Month | Subform | - |
| Invoice Day of Month | ComboBox | Invoice Day of Month |
| Invoice Day of Month_Label | Label | - |
| Invoice Day of Month Other | TextBox | Invoice Day of Month Other |
| Invoice Day of Month Other_Label | Label | - |
| Once Off Invoice Date | TextBox | Once Off Invoice Date |
| Once Off Invoice Date Label | Label | - |
| SpecialPaymentTermsLabel | Label | - |
| How Lead Generated Combo Label | Label | - |
| How Lead Generated Text Label | Label | - |
| SubFrm Sales Brief Finance Programme Fees | Subform | - |
| Total Programme Fee | TextBox | =IIf(IsNull([SubFrm Sales Brief Finance Programme Fees].[Form]![GrandTotalProgra |
| Label153 | Label | - |
| Total Prosperator Distribution | TextBox | =IIf(IsNull([SubFrm Sales Brief Finance Distribution Model Type Fees].[Form]![Gr |
| Label155 | Label | - |
| Additional Marketing Costs | TextBox | Additional Marketing Costs |
| Total Marketing Costs_Label | Label | - |
| Store Standard Marketing Budget | TextBox | Store Standard Marketing Budget |
| Label223 | Label | - |
| Total Contract Value | TextBox | =[Total Programme Fee]+[Total Sub Programme Fee]+[Total Prosperator Distribution |
| Label157 | Label | - |
| Channel Partner Percentage | TextBox | Channel Partner Percentage |
| Channel Partner Percentage_Label | Label | - |
| Channel Partner Value | TextBox | =[Total Programme Fee]*[Channel Partner Percentage] |
| Channel Partner Value_Label | Label | - |
| Channel Partner | ComboBox | Channel Partner |
| Channel Partner Label | Label | - |
| Channel Partner Approver | TextBox | Channel Partner Approver |
| Channel Partner Approver_Label | Label | - |
| Option135 | OptionButton | - |
| Label136 | Label | - |
| Option137 | OptionButton | - |
| Label270 | Label | - |
| SubFrm Sales Brief Extra Sponsor Elements | Subform | - |
| SubFrm Sales Brief Sub Products | Subform | - |
| Special Negotiated Price Notes | TextBox | Special Negotiated Price Notes |
| Special Negotiated Price Notes Label | Label | - |
| Channel Partner Percentage Text | Label | - |
| Label201 | Label | - |
| BBBEE Pillar Label | Label | - |
| Label326 | Label | - |
| Label327 | Label | - |
| Total Sub Programme Fee | TextBox | =IIf(IsNull([SubFrm Sales Brief Sub Products].[Form]![GrandTotalSubProgrammeFee] |
| Label329 | Label | - |
| SubFrm Sales Brief Finance Distribution Model Type Fees | Subform | - |
| Lead Report Frequency | ComboBox | Lead Report Frequency |
| Label297 | Label | - |
| Verification Agency Name | TextBox | Verification Agency Name |
| Label299 | Label | - |
| Principal Verified Date | TextBox | Principal Verified Date |
| Label301 | Label | - |
| VA Pack Date | TextBox | VA Pack Date |
| Label303 | Label | - |
| Procurement Commit to Meeting Label | Label | - |
| Option53 | OptionButton | - |
| Label54 | Label | - |
| Option55 | OptionButton | - |
| Label56 | Label | - |
| Label306 | Label | - |
| SubFrm Sales Brief Marketing ED | Subform | - |
| SubFrm Sales Brief Marketing SD | Subform | - |
| SubFrm Sales Brief Marketing SED | Subform | - |
| SubFrm Sales Brief Marketing SkD | Subform | - |
| SubFrm Sales Brief Selection ED | Subform | - |
| SubFrm Sales Brief Selection SD | Subform | - |
| SubFrm Sales Brief Selection SED | Subform | - |
| SubFrm Sales Brief Selection SkD | Subform | - |
| Label113 | Label | - |
| Option115 | OptionButton | - |
| Label116 | Label | - |
| Option117 | OptionButton | - |
| Label118 | Label | - |
| Label120 | Label | - |
| Option121 | OptionButton | - |
| Label122 | Label | - |
| Option123 | OptionButton | - |
| Label124 | Label | - |
| SubFrm Sales Brief Guiding Deliverables Bespoke | Subform | - |
| SubFrm Sales Brief Guiding Towards | Subform | - |
| Label128 | Label | - |
| Label129 | Label | - |
| Label130 | Label | - |
| SubFrm Sales Brief Bookkeeping Process Description | Subform | - |
| SubFrm Sales Brief Efficacy Non Standard Elements | Subform | - |
| Label133 | Label | - |
| SubFrm Sales Brief SD Initiatives | Subform | - |
| Label137 | Label | - |
| Option138 | OptionButton | - |
| Label139 | Label | - |
| Option140 | OptionButton | - |
| Label141 | Label | - |
| Ignition Description | TextBox | Ignition Description |
| Label143 | Label | - |
| Label144 | Label | - |
| Label145 | Label | - |
| SubFrm Sales Brief Learning Deliverables Bespoke | Subform | - |
| SubFrm Sales Brief Learning Guides Notified | Subform | - |
| Label150 | Label | - |
| Reporting Frequency ID | ComboBox | Reporting Frequency ID |
| Reporting Frequency ID_Label | Label | - |
| Label151 | TextBox | =[Reporting Frequency ID].column |
| SubFrm Sales Brief Principal Referral Contacts | Subform | - |
| SubFrm Sales Brief Principal Referral Contacts Label | Label | - |
| Notes | TextBox | Notes |
| Label221 | Label | - |
| NotifySolutionsArchitect | CommandButton | - |
| Text332 | TextBox | DeliveryNotes |
| Label333 | Label | - |
| Text334 | TextBox | MarketingNotes |
| Label335 | Label | - |
| Text336 | TextBox | FinanceNotes |
| Label337 | Label | - |
| Sales Brief Status ID | ComboBox | Sales Brief Status ID |
| Version Number | TextBox | Version Number |
| Version Number Label | Label | - |
| SalesBriefStatus | TextBox | =[Sales Brief Status ID].Column |
| Label237 | Label | - |
| Status Modified By | TextBox | Status Modified By |
| EditViewStatus | CommandButton | - |
| Sales Brief Number | TextBox | Sales Brief Number |
| Date Status Changed | TextBox | Date Status Changed |
| Label269 | Label | - |
| Modified By | TextBox | Modified By |
| Label138 | Label | - |
| Date Modified | TextBox | Date Modified |
| Label140 | Label | - |
| CloseForm | CommandButton | - |
Subforms
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
- SubFrm
Event Procedures
- Additional_Marketing_Costs_AfterUpdate
- AddPrincipal_Click
- Channel_Partner_AfterUpdate
- Channel_Partner_Approver_AfterUpdate
- Channel_Partner_Percentage_AfterUpdate
- CloseFOrm_Click
- Contract_Duration_AfterUpdate
- Contract_Duration_Other_AfterUpdate
- Contract_End_Date_AfterUpdate
- Contract_Payment_Terms_AfterUpdate
- Contract_Start_Date_AfterUpdate
- Contract_Type_AfterUpdate
- Date_Principal_Needs_Spend_AfterUpdate
- EditViewStatus_Click
- Efficacy_Non_Standard_Elements_AfterUpdate
- Entity_Contracted_AfterUpdate
- Form_AfterInsert
- Form_BeforeInsert
- Form_BeforeUpdate
- Form_Close
- Form_Open
- Manual_Entry_AfterUpdate
- Funding_Fee_Added_to_Programme_Fee_AfterUpdate
- Funding_Fee_Percentage_AfterUpdate
- How_Lead_Generated_AfterUpdate
- Ignition_Description_AfterUpdate
- Invoice_Day_of_Month_AfterUpdate
- Invoice_Day_of_Month_Other_AfterUpdate
- Lead_Report_Frequency_AfterUpdate
- Non_Standard_Bookkeeping_Process_AfterUpdate
- Notes_AfterUpdate
- NotifySolutionsArchitect_Click
- Once_Off_Invoice_Date_AfterUpdate
- Pricing_Mode_AfterUpdate
- Principal_Verified_Date_AfterUpdate
- Relationship_Manager_AfterUpdate
- Procurement_Commit_to_Meeting_AfterUpdate
- Project_AfterUpdate
- Reporting_Frequency_ID_AfterUpdate
- Sales_Manager_AfterUpdate
- Solutions_Architect_AfterUpdate
- Standard_Ignition_Apply_AfterUpdate
- Total_Stipend_Costs_AfterUpdate
- VA_Pack_Date_AfterUpdate
- Verification_Agency_Name_AfterUpdate