Download I The candidate confirms that the work submitted is their own

The above controls the payment subforms, if a customer needs to pay, then the payment form
allows them to do so, if they have paid then the payment details is shown. Otherwise if no
payments are needed then the system states this.
CODE 6
Combo12 = Combo90
This is needed due to there being two search boxes – one for surname and one for swimmer ID.
This makes sure that the combo boxes are always the same. It also mitigates against confusion i.e.
if a user has just accessed Smiths record and then searches for swimmer ID 372, then Smith needs
to change to correlate with the ID 372.
CODE 7
If [Delayed Payment] < Date Then
stDocName = "qry_Update_delayed_payment_field"
DoCmd.OpenQuery stDocName, acNormal, acEdit
End If
The above code deals with the exceptions of where customers delay their payment deadlines.
Once the deadline is passed the code runs a query to show a report showing the details of the
customer so that they can be contacted to allow them to pay. The query also updates the delayed
payment field to null so that it does not create more confusion in the future.
CODE 8
If Text29 = "Staying" Then
[Print Staying Swimmer Specific lesson slip].Visible = True
[Print Moving swimmer specific lesson slip].Visible = False
ElseIf Text29 = "Staying>moving" Then
[Print Staying Swimmer Specific lesson slip].Visible = False
[Print Moving swimmer specific lesson slip].Visible = True
ElseIf Text29 = "Moving" Then
96