Form: Backdoor Frm Add and Edit Pre Ignition Financials

Caption: Add Submission
Record Source: Unbound
Has Code Behind: Yes
Source: ms_access_files\amber\Forms\Backdoor Frm Add and Edit Pre Ignition Financials.txt

Controls (55)

Control Name	Type	Control Source
Calibri	Label	-
Calibri	CommandButton	-
Calibri	TextBox	-
Calibri	ListBox	-
Calibri	ComboBox	-
Calibri	ToggleButton	-
TopLabel	TextBox	-
Submission Year	TextBox	-
Company Name Label	Label	-
Bookkeeper	ComboBox	-
Bookkeeper Assigned Label	Label	-
Submission Month	ComboBox	-
Submission Month Label	Label	-
Pre Ignition ID	TextBox	-
Entrepreneur Company ID	TextBox	-
Turnover	TextBox	-
Label41	Label	-
Cost of Sales	TextBox	-
Label42	Label	-
Expenses No Salary	TextBox	=IIf(IsNull([Expenses Salary]),0,[Expenses Salary])-IIf(IsNull([Salaries]),0,[Sa
Label43	Label	-
Other Income	TextBox	-
Label44	Label	-
Salaries	TextBox	-
Label45	Label	-
Net Asset Value	TextBox	-
Label46	Label	-
Directors	TextBox	-
Label47	Label	-
Permanent Staff	TextBox	-
Label48	Label	-
Contract Staff	TextBox	-
Label49	Label	-
Expenses Salary	TextBox	-
Label51	Label	-
Gross Profit	TextBox	=IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sal
Label53	Label	-
Net Profit Loss	TextBox	=(IIf(IsNull([Turnover]),0,[Turnover])-IIf(IsNull([Cost of Sales]),0,[Cost of Sa
Label55	Label	-
Total Staff	TextBox	=IIf(IsNull([Directors]),0,[Directors])+IIf(IsNull([Permanent Staff]),0,[Permane
Label57	Label	-
Direct Labour Costs	TextBox	-
Label62	Label	-
Cost of Sales ex Direct Labour	TextBox	=IIf(IsNull([Cost of Sales]),0,[Cost of Sales])-IIf(IsNull([Direct Labour Costs]
Label64	Label	-
Total Salaries Paid	TextBox	=IIf(IsNull([Direct Labour Costs]),0,[Direct Labour Costs])+IIf(IsNull([Salaries
Label66	Label	-
Box67	Rectangle	-
Box68	Rectangle	-
Line70	Line	-
Line71	Line	-
Line72	Line	-
Line73	Line	-
CloseFormAndSave	CommandButton	-
CloseForm	CommandButton	-

Event Procedures

• CloseForm_Click
• CloseFormAndSave_Click
• Form_Close
• Form_Open