frmInspectionArrange is opened from frmInspection. It is a columnar form, bound to tblInspection. The Comments field of tblInspection is omitted from the form to prevent it from being accidentally filled in before the inspection takes place. The PropertyNo and Lease controls are read only and cannot be changed. The user can accept the automatically entered staff number or select another from the combo box listing of all staff.
When the inspection date is entered, a check is made that all fields have been completed and the Save command button is enabled if so. The Save button saves the record, and if the property is currently leased, also enables the ‘Print notification’ command button. The Print Notification button prints rptInspectionArrange for the current inspection. (This report is described more fully later in this section)
The close button closes frmInspectionArrange and requeries both subforms on frmInspection. This has the effect of ‘moving’ the inspection record just created from the ‘due list’ to the ‘to be completed’ list.